- Joined
- Feb 13, 2017
- Messages
- 2
- Reaction score
- 0
Hell, please be gentle I am fairly new to Excel!
I am trying to get cells in a worksheet to turn differnt colours depending on date criteria as follows:
If a date occurs today or before the cells to turn red.
If a date is tomorrow plus 30 days the cells to turn yellow.
If a dare is more than 30 days old the cells to turn green.
Now for the hard part! If there is no date in the cell no colouring to be in the cell.
I get the feeling that this should be fairly easy to do but I can't quite get all the things working together.
Can you help?
Thanks in advance. Geordie
I am trying to get cells in a worksheet to turn differnt colours depending on date criteria as follows:
If a date occurs today or before the cells to turn red.
If a date is tomorrow plus 30 days the cells to turn yellow.
If a dare is more than 30 days old the cells to turn green.
Now for the hard part! If there is no date in the cell no colouring to be in the cell.
I get the feeling that this should be fairly easy to do but I can't quite get all the things working together.
Can you help?
Thanks in advance. Geordie