Highlight dates in column H if they are greater than column G by a certain number

Select the dates in column H, goto Conditional formatting...New Rule, select use a formula to determine..., enter this formula,

=$H2>$G2+7

format as required.

Note, change 2 to the first row of the dates in column H.

No, you would select column H and change the 2 to a 1.

Excel will increment the row in the formula just like it does when you copy a formula down.

Originally Posted by Norie

=$H2>$G2+7

Not shure but I think b.b.b. meant "at least 7 days later", so:

=$H2>=$G2+7

'greater than a week or more' sounds like more than a weeek/7 days to me.

'greater than a week' would sound like that, but adding 'or more' to it suggests otherwise to me

On the other hand, who am I to disagree with someone who réálly speaks English :P

"On the other hand, who am I to disagree with someone who réálly speaks English :P"

You obviously haven't been to Scotland!!

Hahahah :D

(Sorry, Norie! )

You could just change H2 to M2 in the formula I posted - no need for an If as long as the expression you use returns TRUE/FALSE.

Another formula entered in Conditional Formatting that will give you the same results is:

Formula:

Please Login or Register  to view this content.

Select column H where you want the formatting applied then create the rule. If you want to change the range that the formatting is applied to, click on Conditional Formatting, Manage Rules. Click on Worksheet to show all the rules if the rule you want isn't showing when your first open Manage Rules. Select the rule that you want to modify, click in Applies To press F2 to enter editing mode and change the cell references using ABSOLUTE references.