Conditional Formatting

[Closed]
Report
Posts
1
Registration date
Wednesday February 20, 2013
Status
Member
Last seen
February 20, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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