Previous Topic Next Topic

2010 Excel Cell Color Changing

Closed
Kurt - Dec 13, 2011 at 02:22 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 14, 2011 at 10:26 AM
Hello,
I have a spread sheet that has due dates, I want to change color of cells to reflect time due

eg:
time of due date red
5 days before due date yellow
10 days before due date green

Then I have another cell of completed date, once this has been entered I would like for all colors to be removed from previous cell.

Could you please help with this? Thank you


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 14, 2011 at 10:26 AM
for that you have to use conditional formatting
-1