condition formula based on date

**pervez** · 12-20-2011, 01:17 AM

i have a inspection chart for machine having every 30 days inspection.
for exp if due date is 20-12-2011. iwil perform inspection and i will enter new date that will be 19-01-2012. i wnt cell color pink before one day on due date cell color red. how can i make it.

**Paul** · 12-20-2011, 01:38 AM

Hi Pervez,

See here for some examples of Conditional Formatting: http://www.contextures.com/xlcondformat03.html#Expiry

That link should take you directly to the example based on expiry date. Hope it helps!

**grizzly6969** · 12-20-2011, 02:12 AM

If dates are column A then highlight column A and conditional format

Please Login or Register  to view this content.

and format Red then add

Please Login or Register  to view this content.

and format pink -- this will highlight pink only 1 day before todays date

**Fotis1991** · 12-20-2011, 04:18 AM

Good morning for me too.

grizzly6969, I am curious to understand what gives you the INT function, in this case.

For me, comes no result ..

Take away the effect applied to something more simple. ie:

For one day before inspection.(Pink colour)>>=A1=TODAY()+1>>>PINK COLOUR

If TODAY, is the day of inspection(Red Colour)>>=A1=today()