If a cell is formatted as a number, and then if I am trying to do a conditional format to that cell, how do I get it to stop recognizing an empty cell as a number?

My condition is if F3<D3, the shade yellow.
If F3 is empty, it is shading yellow.

I really need lessons on conditional formatting.


I have a Min. Target and Max. in three differnt columns, with 31 columns of data to the right of that. I only want to shade cells that fall below the min. or above the Max.

I need to apply this to an entire sheet, and right now, all of the empty cells are getting shaded.

Thanks,
Gary

Attached Files

Wax Weights mini.xlsx (136.6 KB, 12 views)