Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the IF formula to flag dates 21 days prior to deadlin | Excel Worksheet Functions | |||
How do I use the IF formula to flag me 21 days after the date? | Excel Worksheet Functions | |||
flag date within a cell after 15 days have past? | Excel Worksheet Functions | |||
formula to find and flag dates older than 30 days | Excel Worksheet Functions | |||
Having a due date flag in a different colour 30 days from current. | Excel Worksheet Functions |