Hi Guys
If I wanted to GREY OUT certain cells in that row based on the instructions in another cell so if:
A1 = "YES" then it shows cells B1,C1,D1 etc
but if:
A1 = "No" then it GREYS out cells B1, C1,D1 etc
Conditional formatting may not be an option as I have already set the three maxmum types of formatting for the data in those cells meaning the data in those cells turn red, orange or green depending on whats in there.
I just want it to the GREY out if cell A1 specifies YES or NO.
Please advise.
Thanks
Bookmarks