Software

Ask something
Discussion Locked

conditional formatting in Excel

0 helpful
6 replies

by hazion

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to change the color of an entire row based on the date of a particular cell. When a particular date is reached I would like the row to change to a different color instead of just the one cell.

6 replies

by sparent

Make sure you've selected the whole row before bringing up the conditional formatting dialog box.

Change the Condition type from 'Cell Value is' to 'Formula is'. Now, type in the formula you want: it should start with an '=' and evalue to TRUE orFALSE. For example, the first condition's formula (or the first colour, if you may) could be

=Weekday("12/5/99")=1

If your formula needs to refer to other cells values, don't forget to use absolute addressing, as necessary!

Good luck!

by hazion

The answer changes the color of the entire row regardless of what date is in the indicated cell. What I need is the entire row to change color when a particular date is reached; for example, I want to row to change color when 9/5/01 is reached but to remain black until then.

Thanks,
Hazion

by sparent

My formula was just meant as an example: you have to put in the formula you want.

For example:

=a1>1000

is an example of a conditional formatting which will be applied when the first column of the row contains a number greater than 1000!You should be able to figure out your own formula.

Regards,
Steph

This discussion is closed to new replies.