I have a spreadsheet that equals another cell in a different worksheet. The cell that it is referencing is a result of a formula from two other cells. I have 57 cells from a38:a95 that if they equal 0 and I have them conditionally formatted to turn green, but I need to hide the entire row of them. If anything changes in the spreadsheet, say it would happen to turn to yellow because it now equals 1 then I would need it to not be hidden. TIA!
Bookmarks