Hi
Please help this novice!
I have a column of dates which I'd like to apply 3 possible colours to.
- If blank = yellow (I used 'Format only cells that contain blanks')
- If date is in the past = red (I used 'Format only cells that with cell value less than =TODAY()' )
- If date is with 274 days of today (future)= amber (this is the one I probably need help with - have tried various formulas)
Here's my challenges:
- I can get all three conditions to work on their own
- I can get any combo of two conditions to work
- As soon as I add a third it stops working
- I've tried several formulae all of which work independently but not in the group of 3
- No matter what order I place them in I cannot make all three work
- No matter what combo of order and 'stop if true' I use I cant make it work
- I've driven myself insane and now cant work out how to apply any rules down a list - Ive tried ever option in term s of $ $$ or no $ and cant get me head around it (have tried format painter into a blank column as well)
- Literally losing my mind!
PLEASE HELP
Thanks
K Mom
Bookmarks