Highlight data a cfertain color based on date

[cmorten82]

a. Red: urgent action needed – call to follow up again. Days 7+.
b. Yellow: action needed – call to follow up. Day 6&7.
c. Green: no urgent action needed, yet. First 5 days.

This is what I want to do More than 7 days highlight all cells red in that specific row, 6-7 days highlight that row in yellow, first five days row is green.

There are two dates Current date in column A and given date in column G so if Column G had a date of 12/20/15 and column A said 12/29/2105 that that specific row would be highlighted in red. I assume conditional formatting will do the trick and I am guessing that I would format the cell other cells based on the original cells formatting but not sure of the formula I would use to get me there.

[etaf]

setup three rules in conditional formatting

are you comparing A2 to G2
G2 = 12/20/15
A2 = 12/29/15

So A2 is greater than 7

for 2007, 2010 or 2013 excel version
Conditional Formatting

Highlight applicable range >>

Range you want to highlight - lets assume A2:Z1000


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=$A2-$G2 > 7


Format… [Number, Font, Border, Fill] RED
choose the format you would like to apply when the condition is true
OK >> OK

The repeat for
=$A2-$G2 > 5
Yellow

=$A2-$G2 > 0
Green

Now order them as shown and mark "stop if true"
and that should do

The $ is important and will highlight the row - depending on the range applied
at the moment
as you have selected in my example A:Z
then row will highlight A to Z


otherwise
post a sample sheet

[cmorten82]

Thanks this worked perfect.

[etaf]

your welcome , thanks for the rep