• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 82
  • Last Modified:

Conditional format Excel Cell

I have a spread sheet that I want the font in Cell D to be green when the value in cell A is TODAY and red when the Value is OLDER
0
skull52
Asked:
skull52
  • 2
1 Solution
 
Ryan ChongCommented:
try this

Cell D to be green when the value in cell A is TODAY
use conditional fomatting formula:
=INDIRECT("$A$"&ROW())=TODAY()

Open in new window


and red when the Value is OLDER
use conditional fomatting formula:
=INDIRECT("$A$"&ROW())<TODAY()

Open in new window

28983745.xlsx
0
 
Rob HensonFinance AnalystCommented:
Why the INDIRECT??? The ROW part will change based on the Active cell so the Formatting will keep changing.

I assume OP means the cell in D of the same row in A, assuming starting in Row 2 with headers in row 1

For Green:
=$A2=TODAY()

For Red:
=$A2<TODAY()

When copied down the reference to row 2 will increase.

What about where date in A is in future, if that scenario can exist in your workbook?

Thanks
Rob H
1
 
Rob HensonFinance AnalystCommented:
EDIT to statement above; I was thinking of CELL("row") which changes with Active Cell. ROW() does give row number of row in which it is placed.

Even so, no need for INDIRECT.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now