Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to change the color of a row's text based upon the value "No" in the
same row. I want to extend this for the other rows on the same sheet. For example: If cell D2="No" then text in row 2 is red. If cell D3="No" then text in row 3 is red. etc... The sheet is already filled so I need to apply this formatting afterward. Can someone help please? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the rows, from 2 downwards, ensure that your active cell is in row 2,
Format/ Conditional formatting/ Formula is: =$D2="No", and format to red text. -- David Biddulph "Joe M." wrote in message ... I want to change the color of a row's text based upon the value "No" in the same row. I want to extend this for the other rows on the same sheet. For example: If cell D2="No" then text in row 2 is red. If cell D3="No" then text in row 3 is red. etc... The sheet is already filled so I need to apply this formatting afterward. Can someone help please? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Oh, it's easy! Kay, select the column (in this case, column D), and go to
Format Conditional Formatting. You want [Cell value is] [equal to] [no]. Clickie the format button and select red as the "pattern." It'll make anything in row D that has the word "no" change the background to red. "Joe M." wrote: I want to change the color of a row's text based upon the value "No" in the same row. I want to extend this for the other rows on the same sheet. For example: If cell D2="No" then text in row 2 is red. If cell D3="No" then text in row 3 is red. etc... The sheet is already filled so I need to apply this formatting afterward. Can someone help please? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select all the rows to be CF'd
FormatCFFormula is: =$D2="No" Note the $ sign to fix the column D but not the row number. Format the Font to Red. Note: do not let Excel change the $D2 to $D$2 Edit if that's the case. Gord Dibben MS Excel MVP On Wed, 7 Mar 2007 07:55:26 -0800, Joe M. wrote: I want to change the color of a row's text based upon the value "No" in the same row. I want to extend this for the other rows on the same sheet. For example: If cell D2="No" then text in row 2 is red. If cell D3="No" then text in row 3 is red. etc... The sheet is already filled so I need to apply this formatting afterward. Can someone help please? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
But I think the OP was asking for the whole row to go red, not just the cell
in column D? Hence my suggestion for using Formula is, rather than Cell value is. -- David Biddulph "Lauren Giles" wrote in message ... Oh, it's easy! Kay, select the column (in this case, column D), and go to Format Conditional Formatting. You want [Cell value is] [equal to] [no]. Clickie the format button and select red as the "pattern." It'll make anything in row D that has the word "no" change the background to red. "Joe M." wrote: I want to change the color of a row's text based upon the value "No" in the same row. I want to extend this for the other rows on the same sheet. For example: If cell D2="No" then text in row 2 is red. If cell D3="No" then text in row 3 is red. etc... The sheet is already filled so I need to apply this formatting afterward. Can someone help please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format of Odd Visible Rows | Excel Discussion (Misc queries) | |||
conditional format rows | Excel Discussion (Misc queries) | |||
Count Rows with Conditional Format? | Excel Discussion (Misc queries) | |||
How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) | |||
Extend conditional formatting to more than 3 conditions | Excel Worksheet Functions |