Conditional Formating with a formula in 2007

[jae113]

Hello All,

This is my first time using 2007, but I'm also having a brain hiccup about conditional formating!

I have a sheet that uses this formula =DATEDIF(H2,TODAY(),"D") in column I. If that value is equal to or greater than 90, I'd like to highlight the cooresponding row, columns A through M.

Do I have to use an IF THEN? I honestly I'm having problems even remembering how to do that, nevermind that I'm not sure if >=90, is correct to use!

Any and all help greatly appreciated.

Jae

 

[T. Valko]

Hello All,

This is my first time using 2007, but I'm also having a brain hiccup about conditional formating!

I have a sheet that uses this formula =DATEDIF(H2,TODAY(),"D") in column I. If that value is equal to or greater than 90, I'd like to highlight the cooresponding row, columns A through M.

Do I have to use an IF THEN? I honestly I'm having problems even remembering how to do that, nevermind that I'm not sure if >=90, is correct to use!

Any and all help greatly appreciated.

Jae

You can use a shorter formula:

=TODAY()-H2

Format as General or Number

To apply the conditional formatting...

• Select the range A2:M2
• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
• =$I$2>=90
• Click the Format button
• Select the desired style(s)
• OK out

 

[jae113]

I tried this formula as well, and all it seems to do is fill in the entire selected range! =$I$2>=90

Hmmmmm, I did keep the original fomula up top, but I don't think that should matter. And I checked, there are no other conditions in the ws.

 

[T. Valko]

I tried this formula as well, and all it seems to do is fill in the entire selected range! =$I$2>=90

Hmmmmm, I did keep the original fomula up top, but I don't think that should matter. And I checked, there are no other conditions in the ws.

If I2 is >=90 then it SHOULD format the ENTIRE range.

That's what you wanted to do, isn't it?

Is this not working correctly?

 

[jae113]

Oh, no I'm sorry! I want it to only fill those rows when the value in column I is 90 or greater.

So for example, if I2 is 90, I would like row 2 to be filled yellow, and then if I8 is 97, I would like that row filled yellow BUT none of the intervening rows. in the range.

Sorry for the confusion and thanks for all the help!

 

[T. Valko]

You can use a shorter formula:

=TODAY()-H2

Format as General or Number


To apply the conditional formatting...

• Select the range A2:M2
• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
• =$I$2>=90
• Click the Format button
• Select the desired style(s)
• OK out

Oh, no I'm sorry! I want it to only fill those rows when the value in column I is 90 or greater.

So for example, if I2 is 90, I would like row 2 to be filled yellow, and then if I8 is 97, I would like that row filled yellow BUT none of the intervening rows. in the range.

Sorry for the confusion and thanks for all the help!

Ok, then just change the formula to:

=$I2>=90

 

[jae113]

Thank you so much! I can't believe I couldn't get that for the life of me! Once again, Biff to the rescue

 

[T. Valko]

Thank you so much! I can't believe I couldn't get that for the life of me! Once again, Biff to the rescue

You're welcome. Thanks for the feedback!