Thanks:  0
Likes:  0

# Thread: Multiple Conditional Formatting Problem

1. ## Multiple Conditional Formatting Problem

Hello, everyone!

Thanks in advance for devoting your time to my problem.

I am stuck at a conditional formatting of a range of cells (do not have a problem when formatting one single cell but would like to avoid copy/pasting the formatting each time).

- I want to achieve the following:

Higlight each cell in a range if containing a specific text (let's say "YES") and if the date associated with the column which that cells belongs to has passed. Not sure if this was clear enough, so I will try to explain it in another way.

If a cell containing specific text (i.e. "YES") is in the column "C" and this column (actually cell "C1") is associated with a date that has passed, I want that cell highlighted with a specific color. Now, where I am stuck at is applying the conditional formatting to the whole range. It is probably a trivial question for many but I am still in the process of learning.

For single cells I am using the formula : =AND(C1
I hope I was not too confusing.

Best regards,
MJ

2. ## Re: Multiple Conditional Formatting Problem

Originally Posted by Miodrag J

For single cells I am using the formula : =AND(C1< today(), c2="YES" ).

So what i want to do is for example apply this conditional formatting the range c2:e10. how arrange custom formula so that it responds change of dates in columns c1:e1 and above mentioned specific text each particular cell range?

I hope I was not too confusing.

Best regards,
MJ

Select cells C2:E10 and enter this CF formula
=AND(C\$1< TODAY(), C2="YES")

Excel will automatically adjust the formula for each cell.

Forum TIP: The bulletin board editor sometimes interprets < and > symbols as HTML code. When you use them here in a formula, put a space before and after them.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•