I am working on a spreadsheet where I have entered a formula in column C.
Column C's value is a caculation based on columns A-B.
Sometimes column C is blank, but it still has a formula in it.
When cells in column C are blank (but contain a formula), I would like to set formatting a certain way (in this case no formatting).
The other cells are formatted based on their values as follows:
values greater than 5 and less than 11 are highlighed yellow
values greater than 11 are highlighted red
I have been trying to write formulas, trying to use the available options in conditional formatting, reordering the conditional formatting for this column, but nothing is working. I have also tried to search this specific issue without any sucess. Can someone help me please.