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

i need the date to flag up red if it goes over 30 days from the date it was
logged

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

Use conditional formatting on your date cell

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

Mike

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged

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

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

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged

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

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


"Mike H" wrote:

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

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged

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

Select Column A

Then FORMAT== Conditional Formatting:

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

Select colour.

OK



"Pali" wrote:

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


"Mike H" wrote:

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

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged

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

if i wantd to do more than one cell how would i do it

"Toppers" wrote:

Select Column A

Then FORMAT== Conditional Formatting:

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

Select colour.

OK



"Pali" wrote:

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


"Mike H" wrote:

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

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged

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

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

"Toppers" wrote:

Select Column A

Then FORMAT== Conditional Formatting:

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

Select colour.

OK



"Pali" wrote:

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


"Mike H" wrote:

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

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged