Where in this Great Southern Land are you hiding?
Try the following code placed in the worksheet module:-
Private Sub Worksheet_Activate()
Dim c As Range
For Each c In Range("F5:U19")
If c.Value = 0 Then
c.Interior.ColorIndex = 8
The code is a Worksheet_Activate event code so once you open the relevant sheet, the code will execute.
To implement the code:-
- Right click on the relevant sheet tab.
- Select "View Code" from the menu that appears.
- In the big white field that then appears, paste the above code.
You can change the ColorIndex to suit yourself.
Once you enter the code, you'll then need to save the workbook with the .xlsm file extension.
I hope that this helps.