james_simpson1998
New Member
- Joined
- Jul 30, 2020
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi all,
I am trying to do some conditional formatting.
What I am trying to achieve is this:
I want the date in cells in Column B to fill RED if the date in the cells in Column B is 5 days after the date in the cells in Column A.
And then I want to the same but for 4 days after to be ORANGE.
and then anything 3 days after to be GREEN.
Does that make sense and is it possible?
Thanks all,
I am trying to do some conditional formatting.
What I am trying to achieve is this:
I want the date in cells in Column B to fill RED if the date in the cells in Column B is 5 days after the date in the cells in Column A.
And then I want to the same but for 4 days after to be ORANGE.
and then anything 3 days after to be GREEN.
Does that make sense and is it possible?
Thanks all,