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)

If I have understood correctly what you need, select G3:AI50 and use as CF. Format as needed
Some of your empty cells are null cells, but others are blank, which makes it a little awkward

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Awesome,
Seems to be working perfectly.
Where do I click on the Scale?

Thank You,
Gary

It's in the upper right corner of my post next to the post number - Thx in advance, we don't get much rep around here

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post