S
Sherry Fox
I have a spreadsheet I need to set up conditional formatting on. The date
that all the formulas will compare to is in cell C2. Let me give you an
example of what I want.
C2 = 8/23/03 (today's date)
E13 = 8/23/03 (due today would be red)
E14 = 8/25/03 (due within 3 days would be yellow)
E15 = 9/1/03 (due within 7 days would be green)
I know I would need to create 3 conditional formats within each cell, but I
am just unsure of what formula I should use. In addition, I also want to be
able to use the same conditional formats for the corresponding row cells.
This way when something is due the entire row would be highlighted the
appropriate color. Thanks so much!
Sherry
that all the formulas will compare to is in cell C2. Let me give you an
example of what I want.
C2 = 8/23/03 (today's date)
E13 = 8/23/03 (due today would be red)
E14 = 8/25/03 (due within 3 days would be yellow)
E15 = 9/1/03 (due within 7 days would be green)
I know I would need to create 3 conditional formats within each cell, but I
am just unsure of what formula I should use. In addition, I also want to be
able to use the same conditional formats for the corresponding row cells.
This way when something is due the entire row would be highlighted the
appropriate color. Thanks so much!
Sherry