Excel 2010 - conditional formatting - blank cells

**Phil81503** · 07-01-2013, 01:48 PM

In Excel 2010, how do you apply CONDITIONAL FORMATTING to blank cells?

What I have done in the past is use this ... if [cell] ="" ... apply the conditional format to the cell (fill the cell with an assigned color).

This particular worksheet is used to track and rotate employees' non work day in a weekly schedule. All employees have rotating days.

It has worked perfectly until the first time i edited the file in Excel 2010.

???

**Special-K** · 07-01-2013, 02:05 PM

There is no IF required for a conditional format or are you talking about VBA (you dont say)?
A standard conditional format looks like this

=(A1=3)
and format as red

No IF required

**Ace_XL** · 07-01-2013, 02:38 PM

In CF try

- Format only cells that contain
- Blanks (in first drop down)
- Format (as desired)

**Phil81503** · 07-01-2013, 02:50 PM

This is the formula that resides in the cell:

=IF(D72="",+$A$30,IF(D73="",+$A$31,IF(D74="",+$A$32,IF(D76="",+$A$34,IF(D77="",+$A$35,"")))))

Utilizing the conditional formatting "Highlight Cells Rules" ... "Equal To" ...

the typing "" in the field, selecting custom format and fill [selected color].

Conditional formatting is simply looking for the blank cell [""] and should then fill the cell with the selected [assigned] color.

This worked in Excel 2003 and 2007...what happened in 2010?

**Ace_XL** · 07-01-2013, 02:55 PM

Utilizing the conditional formatting "Highlight Cells Rules" ... "Equal To" ...

the typing "" in the field, selecting custom format and fill [selected color].

type in ="" instead of just ""