Conditional formating

R

Ryan

How do I get this to work with conditional formating?
Cell Value Is Equal To ="TOTALS" OR "LOCATION TOTALS"
Can you use or? I know I could use a 2nd condition, but 3 conditions will
not cut it unless i can use the or.
 
K

Ken

Try ... Conditional "Formula is"

=or(Cell="Totals",Cell="Location Totals")

or

=right(Cell,6)="Totals"

HTH ... Kha
 
S

Sandy Mann

You could use OR:

=OR(A1="Totals",A1="Location Totals")

or you can use RIGHT():

=RIGHT(A1,6)="Totals"

But that will pick up every entry ending in "totals"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top