Conditional formatting not working when used on cells with formulas

Looks like you have the workbook set not not display zeroes? Either way I would think the result of the COUNTIF formula in row 5 would be 0 if it doesn't find anything.

You will also need to change the "Applies to" range, you might know this already just checking.

Hi nick.williams, thanks for replying. Yes workbook is set to not display '0's as this is required on another sheet in the workbook. Is what i am attempting not possible without this enabled?

What does the 'applies to' range need to change to? For the example cell selected, this set for formatting would only apply to that one cell as the next cell along, the formula references would change.

Thanks

It doesn't stop you doing anything, it just makes it harder to tell the difference between a 0 and a blank cell. With the COUNTIF formula in row 5, if they appear blank they will actually be 0. So you need =0 instead of =""

You need to change the Applies to range to whatever range you want it to apply to. At the moment it will only affect F4.

Conditional formatting applies as though you are copying a formula from the top left cell of the range. For example, if you have a formula of =F5=0 applying to $F$4:$G$4, then it will look at F5 when applying to F4 but look at G5 when applying to G4. If you want to always look at the same cell then use the $ in the formula. But how you have it set up looks fine for what you described.

Amazing, its working now I've changed the formula to =0. I knew it would be something as simple as that but I just couldn't figure it.

Thank you!!