CODEWITHSUNDEEP
exceldatetimeexcel-formulaexcel-2010conditional-formatting
user2532255
user2532255

Reputation: 35

Conditional format based on a cell's color

I have a column with conditional formatting rules set to make the background one of three colors based on how close the date is in comparison to the current date (Today's date + 7, + 15, +30 days).

I want to extended the conditional format across to effect the entire row, rather than just the individual cell for the user more easily to see which item's date is approaching.

Is it possible to do a conditional format using a cell's format?

Update: To explain it further. Conditional format is set to a column: if a cell value is in between today's date and 7 days from today's date, it is formatted to have a green background. I want this format to extend across the ROW in which the value turns green.

Upvotes: 2

Views: 41063

Answers (2)

guitarthrower
guitarthrower

Reputation: 5834

Just change the Applies to range to all the columns you want to be colored. You'll need to make sure you lock down the reference of the date column in the Conditional Formatting rule.

For example:

If your data is in columns A:H, then your Applies to range will be =$A:$H

If your date column is column C, then your conditional formatting rule (for C1) would be something like:

=AND($C1>=TODAY(),$C1<=TODAY()+7)

Upvotes: 1

pnuts
pnuts

Reputation: 59485

Please try:

SO25392253 example

where the three formulae are:

Green =$A1<TODAY()+7
Orange =$A1<TODAY()+15
Yellow =$A1<TODAY()+30

and I have assumed each 'row' spans A:Z and your dates are in ColumnA.

This will highlight dates earlier than today also (though could easily be adjusted).

Upvotes: 5

Related Questions