I have a bunch of conditional formatting set up on one of my spreadsheets to turn a number red if its higher than say 2.
The ones that turn red are a reminder to do a certain job task. I would like to manually highlight that cell(yellow) to tell me and others that that task has been completed.
But because I have it conditionally formatted, it wont allow me to hightlight the cell. Is there anyway to manually hightlight the cell on top of a cell that has conditional formatting??
THanks for all your help!
Bookmarks