Conditional Formatting Not Working on Cells with Formula

1
votes

I can't get this to work. Before, the cells I selected will highlight RED if the cell contains a number >5. But now that I entered a formula in the cells, conditional formatting doesn't work.

The formula I added is: 

=IF(F135>0,$D$2-F135,"Not Received")

Basically, what I want is if the result is >5, it gets highlighted RED.

Please help.

1
excelconditional-formatting
Which cell are you applying this too? – QHarr
I'm applying the conditional formatting on cells that contain the formula I mentioned. – Beginner1

1 Answers

1
votes

Depending on where you want this you can use formula such as

AND(ISNUMBER(H135),H135>5)

Formula