Conditional Formatting

[andy_2610]

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>

Thanks for your in advance!
Andrew

 

[Special-K99]

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

 

[shobolos]

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

 

[Special-K99]

=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.

 

[andy_2610]

Thanks guys

 

[andy_2610]

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

 

[shobolos]

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.

 

[Special-K99]

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

 

[andy_2610]

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

It keeps reverting to $C$1.