Previous Topic Next Topic

Automatically change cell color on a certain

Closed
lostntranslation - Jun 3, 2010 at 01:20 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 3, 2010 at 01:40 PM
Hello,

I am trying to create a spreadsheet that is going to contain a lot of dates. What I'm trying to setup is say I have a future date such as 30 Aug 10 in cell E11. when the date in E11 is within 30 days of todays date, i want cell E11 to change color. know if I enter a new date in E11, say 30 Aug 11, the cell would go back to no color.


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 3, 2010 at 01:40 PM
You are talking about conditional formatting

use conditional formatting

=AND(E11<> "", E11<today() + 30, E11>=Today())
and choose color

Formula says

IF E11 is not blank

AND

E11 is greater or equal to today

AND

E11 is less than 30 days from today
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Ig stories from close friends to public
Darren -
zara -

31 responses