Hi, I don't know whether this can be done with a simple conditional formatting, let's ask the experts
I have this table with dates on 1st row and column, and I'd like the table cells to be color-filled if a date on row 1 matches one I manually insert on column A.
To make it more difficult (but this is a 2nd step), it should be orange-filled if the date on column A is "Temp", green-filled if "Final". Temp and Final info are on column B.
I'm attaching the spreadsheet I'm working on. I've manually added the orange / green colouring where it should go.
Also is there a way for manual formatting to prevail on the conditional one? I.e. greening cell BI6 manually while there's a rule greying all weekend cells?
Thanks for your help!
Bookmarks