DebsTurner
New member
- Joined
- Oct 5, 2016
- Messages
- 4
- Reaction score
- 0
- Points
- 0
I have a column that holds a date (F2). This is the "received" date. Then i have another column (I2) that i work out and input a "target" date that is 20 working days after that in F2. What i want is when I2 is between 0 - 10 working days from F2 to be green, 11 - 20 working days to be amber, and when it's 21 days and over, to be red. Does that make sense?
Obviously i would like the "fill" to be rag rated, not the font, but i don't know how to do that on here :smile:
Many thanks in advance.
Debbie.
Obviously i would like the "fill" to be rag rated, not the font, but i don't know how to do that on here :smile:
Many thanks in advance.
Debbie.
F2 | I2 |
04/09/16 | 30/09/16 |
16/09/16 | 14/10/16 |
25/09/16 | 21/10/16 |