Previous Topic Next Topic

Conditional Formatting

Closed
playtone22
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
 - Feb 20, 2013 at 12:55 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 - Feb 20, 2013 at 03:59 PM
Hello,
I'm using Excel 2010 (not sure whether or not that matters)

I'm not very familiar with conditional formatting, so I need help with something: I would like to change the color of the font of an ENTIRE row based on the value of one cell. Example: I would like the font of the row 22 to be blue if "M22" is blank; if "M22" has a date in it, then I want the font to be black (I'm okay with the background color changing instead, if that's easier). How do I apply the formatting on the other entire row? (or can I?)

1 reply

Answer 1 / 1
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
 769
Feb 20, 2013 at 03:59 PM
Lets say you want to apply to whole sheet this

then
1. Select cell A1
2. Select Al Rows
3. Go to Conditional Format
4. Enter formula
=isNumber($M1)
5. Apply the format that you want
0