Hi there,
I'm trying to do a spreadsheet that uses Conditional Formatting to display coloured cells for certain values.
The rules I need it to display are:
If B9 says 1 Day, 2 Day or Season Pass then C9 and D9 are highlighted
Once 1 Day, 2 Day or Season Pass has been enter into C9 or D9, then the other value goes blank
If 1 day or 2 day is entered into C9 then G9, H9, I9, J9 and L9 are highlighted until values are filled in
If 1 day or 2 day is entered into D9 then G9, H9, I9, J0 and K9 are highlighted until values are filled in
If Own is entered into C9 or D9 then only L9 is highlighted
I've attached the spreadsheet i'm working with.
If someone can help me it would be hugely helpful!!
Thank you kindly in advance!!
Hannah
Bookmarks