Conditional Formatting
 

I'm trying to set the conditional formatting on a row, depending upon
the formula below:

="(S35) (E35+30)"

It doesn't work.

S and E are date columns. I have verified that S35 is over 30 days
beyond the date in column E. It should work, but it isn't working.
So then I tried a simpler formula. I tried just checking to see if
E35 = 4/26/2007

It still didn't do anything. It's supposed to turn the background
color to Red. I've tried setting this from inside Excel, and I've
also tried doing it in VBA setting the colorIndex. It doesn't work in
either case.

Right now, I'm just trying to get it to work from Excel, using the
Format toolbar selection, and then the Conditional Formmatting option
below that. It's all set. The background color is set. The formula
is there, yet it doesn't work. Why? What could I be doing wrong?

Conditional Formatting
 

change cell value is to formula is:

then use

=$S$35 $E$35+30

as the formula.

get rid of the quotes.


--
Regards,
Tom Ogilvy

"HockeyFan" wrote:

I'm trying to set the conditional formatting on a row, depending upon
the formula below:

="(S35) (E35+30)"

It doesn't work.

S and E are date columns. I have verified that S35 is over 30 days
beyond the date in column E. It should work, but it isn't working.
So then I tried a simpler formula. I tried just checking to see if
E35 = 4/26/2007

It still didn't do anything. It's supposed to turn the background
color to Red. I've tried setting this from inside Excel, and I've
also tried doing it in VBA setting the colorIndex. It doesn't work in
either case.

Right now, I'm just trying to get it to work from Excel, using the
Format toolbar selection, and then the Conditional Formmatting option
below that. It's all set. The background color is set. The formula
is there, yet it doesn't work. Why? What could I be doing wrong?