I would like to use conditional highlighting to highlight cells that are equal to 0 but are not blank. It seems that Number assumes a blank cell that is formatted as a number is equal to 0. I know from your videos that you can use conditional formatting to make a cell that contains zero a blank, is there a way to do the opposite, i.e. make a cell that is blank not be zero?
Everyday I enter hours worked for various activities on a task tracking spreadsheet. The hours field is blank until I enter the hours worked for that activity for that day. I want to use conditional highlighting to distinguish between blank cells and cells that contain zero.