Conditional formating

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

 

[Ken]

Try ... Conditional "Formula is"

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

or

=right(Cell,6)="Totals"

HTH ... Kha

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Ryan]

Thank you very much!!

Try ... Conditional "Formula is"

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

or

=right(Cell,6)="Totals"

HTH ... Kha