| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting dates in 2007
Hi I am working in excel 2007.
I have to columns filled with dates down to row 35. I want to set the background of the cells to red if the dates shown are less than today. I can get this to work for one cell with this formula: =$D$2<=TODAY() So far I have been creating a new rule for each cell. Once I got down to cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've tried to set one conditional format for all the cells but then this sets all the cells background to red (which shouldn't happen as most of the dates are in the future so far). Can anyone help me out please? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting dates in 2007
I am not using 2007 at the moment but it sounds odd that you create a new
rule for each cell if the conditional formatting is the same, just copy the formatting to the other cells and use one rule -- Regards, Peo Sjoblom "Lucy" wrote in message ... Hi I am working in excel 2007. I have to columns filled with dates down to row 35. I want to set the background of the cells to red if the dates shown are less than today. I can get this to work for one cell with this formula: =$D$2<=TODAY() So far I have been creating a new rule for each cell. Once I got down to cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've tried to set one conditional format for all the cells but then this sets all the cells background to red (which shouldn't happen as most of the dates are in the future so far). Can anyone help me out please? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting dates in 2007
Assume your dates are in the range D2:E37
Select the range D2:E37 Goto Home tabStylesConditional FormattingNew RuleUse a formula to determine..... =AND(D2<"",D2<=TODAY()) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Peo Sjoblom" wrote in message ... I am not using 2007 at the moment but it sounds odd that you create a new rule for each cell if the conditional formatting is the same, just copy the formatting to the other cells and use one rule -- Regards, Peo Sjoblom "Lucy" wrote in message ... Hi I am working in excel 2007. I have to columns filled with dates down to row 35. I want to set the background of the cells to red if the dates shown are less than today. I can get this to work for one cell with this formula: =$D$2<=TODAY() So far I have been creating a new rule for each cell. Once I got down to cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've tried to set one conditional format for all the cells but then this sets all the cells background to red (which shouldn't happen as most of the dates are in the future so far). Can anyone help me out please? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting dates in 2007
Thank you for giving me the correct formula!
"T. Valko" wrote: Assume your dates are in the range D2:E37 Select the range D2:E37 Goto Home tabStylesConditional FormattingNew RuleUse a formula to determine..... =AND(D2<"",D2<=TODAY()) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Peo Sjoblom" wrote in message ... I am not using 2007 at the moment but it sounds odd that you create a new rule for each cell if the conditional formatting is the same, just copy the formatting to the other cells and use one rule -- Regards, Peo Sjoblom "Lucy" wrote in message ... Hi I am working in excel 2007. I have to columns filled with dates down to row 35. I want to set the background of the cells to red if the dates shown are less than today. I can get this to work for one cell with this formula: =$D$2<=TODAY() So far I have been creating a new rule for each cell. Once I got down to cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've tried to set one conditional format for all the cells but then this sets all the cells background to red (which shouldn't happen as most of the dates are in the future so far). Can anyone help me out please? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting dates in 2007
You're welcome!
-- Biff Microsoft Excel MVP "Lucy" wrote in message ... Thank you for giving me the correct formula! "T. Valko" wrote: Assume your dates are in the range D2:E37 Select the range D2:E37 Goto Home tabStylesConditional FormattingNew RuleUse a formula to determine..... =AND(D2<"",D2<=TODAY()) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Peo Sjoblom" wrote in message ... I am not using 2007 at the moment but it sounds odd that you create a new rule for each cell if the conditional formatting is the same, just copy the formatting to the other cells and use one rule -- Regards, Peo Sjoblom "Lucy" wrote in message ... Hi I am working in excel 2007. I have to columns filled with dates down to row 35. I want to set the background of the cells to red if the dates shown are less than today. I can get this to work for one cell with this formula: =$D$2<=TODAY() So far I have been creating a new rule for each cell. Once I got down to cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've tried to set one conditional format for all the cells but then this sets all the cells background to red (which shouldn't happen as most of the dates are in the future so far). Can anyone help me out please? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting dates in 2007
That is what I was trying to do - create one formula for all the cells.
I was originally entering code similar to this: =$F$2:$F$35<=TODAY() But this resulted in all the cells being formatted (which was wrong). I did not know what the correct formula would be. "Peo Sjoblom" wrote: I am not using 2007 at the moment but it sounds odd that you create a new rule for each cell if the conditional formatting is the same, just copy the formatting to the other cells and use one rule -- Regards, Peo Sjoblom "Lucy" wrote in message ... Hi I am working in excel 2007. I have to columns filled with dates down to row 35. I want to set the background of the cells to red if the dates shown are less than today. I can get this to work for one cell with this formula: =$D$2<=TODAY() So far I have been creating a new rule for each cell. Once I got down to cell D14 Excel crashed as it couldn't handle 14 conditional formats. I've tried to set one conditional format for all the cells but then this sets all the cells background to red (which shouldn't happen as most of the dates are in the future so far). Can anyone help me out please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting with Dates | Excel Worksheet Functions | |||
| Conditional Formatting with Dates | New Users to Excel | |||
| Conditional Formatting Dates | Excel Discussion (Misc queries) | |||
| Conditional Formatting - Dates | Excel Discussion (Misc queries) | |||
| Help with Conditional Formatting (Dates) | Excel Discussion (Misc queries) | |||
Hybrid Mode
