Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More Conditional Formatting
I posted a thread earlier:
"If i have a date in column A and have a formula that calculates 90 days from that date to Column B and I want to add conditional formatting to Column B that flags 120, 90, and 60 days from the column B date how would I go about doing that?" I receved the following (which works great): =AND($B1TODAY(),$B1<=TODAY()+60) <- Flags Red =AND($B1TODAY()+60,$B1<=TODAY()+90) <-Flags Orange =AND($B1TODAY()+90,$B1<=TODAY()+120) <-Flags Yellow But I need the 60 days to go beyond that, how would I do that? (i.e. The date in Column B is 1 Dec 08 how do i get the flag to stay red after the date has passed so that i know it is now overdue.) Would i have to do an additional CF to the cell? Please help. -- Frecks1983 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More Conditional Formatting
Try amending just this condition:
=AND($B1TODAY(),$B1<=TODAY()+60) <- Flags Red to: =$B1<=TODAY()+60 -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "Frecks1983" wrote: I posted a thread earlier: "If i have a date in column A and have a formula that calculates 90 days from that date to Column B and I want to add conditional formatting to Column B that flags 120, 90, and 60 days from the column B date how would I go about doing that?" I receved the following (which works great): =AND($B1TODAY(),$B1<=TODAY()+60) <- Flags Red =AND($B1TODAY()+60,$B1<=TODAY()+90) <-Flags Orange =AND($B1TODAY()+90,$B1<=TODAY()+120) <-Flags Yellow But I need the 60 days to go beyond that, how would I do that? (i.e. The date in Column B is 1 Dec 08 how do i get the flag to stay red after the date has passed so that i know it is now overdue.) Would i have to do an additional CF to the cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |