Previous Topic Next Topic

Conditional Formatting

Closed
playtone22 Posts 1 Registration date Wednesday 20 February 2013 Status Member Last seen 20 February 2013 - 20 Feb 2013 à 12:55
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Feb 2013 à 15:59
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Feb 2013 à 15:59
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional Formatting - highlight overdue dates
TanyaRT -
TanyaRT -

2 responses