Solved

# Conditional format Excel Cell

Posted on 2016-11-17
16 Views
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
Question by:skull52
• 2

LVL 49

Accepted Solution

Ryan Chong earned 500 total points
try this

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

and red when the Value is OLDER
use conditional fomatting formula:
``````=INDIRECT("\$A\$"&ROW())<TODAY()
``````
28983745.xlsx
0

LVL 31

Expert Comment

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

LVL 31

Expert Comment

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

## Join & Write a Comment Already a member? Login.

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity anâ€¦
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

#### 771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!