i need the date to flag up red if it goes over 30 days from the d.

  • Thread starter Thread starter Guest
  • Start date Start date
Use conditional formatting on your date cell

Cell value is - Less than - ="today()-30"

Mike
 
Pali,

Please ignore previous post which is completely wrong!!!

Still conditional formatting so with your date in A1 press

Format - conditional formatting - formula is - =(TODAY()-A1)>30

and apply your colour.

Mike
 
i have type the following i the cell =(TODAY()-A1)>30 and it came up false.
and if i appy the colour will that come up for as many itme i put in
 
Select Column A

Then FORMAT==> Conditional Formatting:

FormulaIS: =AND(A1<>"",TODAY()-A1>30)

Select colour.

OK
 
i am no i may sound stupid sorry.
i have a speadsheet that has date already in it and some dont. but i would
like for them to flag up in any colour to let me know they have gone over 30
days.
i want to flag up from l3 to l50
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Colour code dates 1
Trailing 30 days sum calculation with excel 1
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
Excel Excel due and overdue date colours 2
Flagging up dates in cells 1
Conditional Format help 5
if then and conditional formatting of dates 2
how do i get a date to turn red if it is within 90 days of today? 1

Back
Top