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?

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?

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?

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?

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?

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?