Extend conditional format to other rows
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? |
Extend conditional format to other rows
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? |
Extend conditional format to other rows
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? |
Extend conditional format to other rows
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? |
Extend conditional format to other rows
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? |
All times are GMT +1. The time now is 01:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com