Question Pertaining to Conditional Formatting

[hardworkingprofessional84]

Hello community! This is my first question~

I am trying to highlight an entire row if the data corresponding to that row in the column I created for "Percent of Profit/Cost" is over 50%.

So basically what I have done is gone into Conditional Formatting--->
Formula is =F$13>=.5

and then formatted the cell's background to be highlighter yellow if that happens.

For some reason, cells that do not have ANY data in them are highlighted yellow, but if you manually input a cost that makes the Profit/Cost % < 50%, then they drop the highlight.

Logically it doesnt make any sense, because a cell without any data in it should be = 0. And 0 is definitely < 50.

Any suggestions?
Thanks!

 

[Smitty]

Welcome to the Board!

If you have multiple rows, the formula would be =$F13>=.5. Also note that if your range doesn't start at row 13, then the 13 needs to be the starting row of your range. E.G. A1:H20 would be =$F1>=.5

HTH,

 

[abmati]

In this case there is no need to put Formula for conditional formatting, you can use cell value (Formal only cells that contain)>0.5

 

[hardworkingprofessional84]

If I so much as put a 0 in for the percentage, it will take care of the yellow highlighted background. I really don't understand it. How do I fix it?

 

[cb12]

abmati is right there is no need to use formula driven conditional formatting. Simply use "highlight cells rules" -> "Greater Than" and then 0.5 or whatever figure you need