I have a spreadsheet with a number of conditional formats which colour cells in red when they need to be filled/completed. I also have a conditional format to make the entire sheet zebra lined. I would like another (presumably) conditional format which means that until a cell has something entered on any given row all that is displayed is the zebra formatting, and not the red cells. Meaning I do not have a page full of red cells! Example sheet attached.
(Have tried to upload example of what I mean but it failing to do so, using a remote access to work computer and is struggling)
Hurg
Bookmarks