Conditional Formatting

[abailey]

Does anyone know how to set up a formula so that multiple entries bring
up the same color?

Ex:

On a checklist, I want anything that is entered as “Fail-invalid”,
“Fail-Broken”, and “Fail-Removed” to be displayed in red. Currently I
can not find out how to include this all in one conditional format
entry. I am using the other 2 conditional format entries for other
things.

Thanks and help would be greatly appreciated.

-Adam

 

[Debra Dalgleish]

Select the cells that you want to format
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula, referring to the active cell:

=OR(B3="Fail-Broken",B3="Fail-Removed",B3="Fail-Invalid")

Click the Format button, and select on the Patterns tab, select Red.
Click OK, click OK.

 

[Dave Peterson]

Can you just format any entry that starts with "Fail-"?

if yes, you could use a formula like:
=LEFT(A1,5)="fail-"

If you have lots of entries and you have to match them exactly, you could create
a list on a different worksheet and give that list a nice name: MyFailList
(via insert|Name)

Then you could use a formula like:
=match(a1,myfaillist,0)

=match() returns #n/a if not found. And conditional formatting will treat that
as False.

=match() returns a positive integer if it was found. And conditional formatting
will treat that as True.

 

[abailey]

Thanks for the feedback, I really appreciate it.