# Conditional Formatting

#### andy_2610

##### Board Regular
Hi all, I have a brain fart.. I can't figure out how to conditional format.
Below is an example...
I want to conditional format the rows yellow through column C if column C shows "DELIVERED" OR "COMPLETED" OR "PAID".

 A B C D 1 5784 500 DELIVERED 2 5785 300 EN ROUTE 3 5786 400 COMPLETED 4 5787 100 PAID

<tbody>
</tbody>

Andrew

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Select C1

Conditional Formatting
New Rule
Use a formula to determine...

=(OR(C1="DELIVERED",C1="COMPLETED",C1="PAID"))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

=find(\$c2,("delivered"&"completed"&"paid"))

=find(\$c2,("delivered"&"completed"&"paid"))

That wont work.
Entering that formula on a blank sheet returns 1 (TRUE)
even though C2 is an empty cell
Entering PAID in C2 returns #VALUE

For each successful FIND in that formula the other two words to find will fail.

Thanks guys

Is there a way to highlight the whole row when it meets the criteria?
Select C1

Conditional Formatting
New Rule
Use a formula to determine...

=(OR(C1="DELIVERED",C1="COMPLETED",C1="PAID"))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

That wont work.
Entering that formula on a blank sheet returns 1 (TRUE)
even though C2 is an empty cell
Entering PAID in C2 returns #VALUE

For each successful FIND in that formula the other two words to find will fail.

My formula works perfectly when added as a rule in conditional formatting.

Your formula will only highlight one cell per row and is more cumbersome.

Select the whole row before entering the formula and change C1 to \$C1

Select the whole row before entering the formula and change C1 to \$C1

It keeps reverting to \$C\$1.

Replies
9
Views
455
Replies
4
Views
800
Replies
1
Views
733
Replies
7
Views
1K
Replies
9
Views
324

1,196,250
Messages
6,014,232
Members
441,808
Latest member
xplainer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back