Conditional formating
 

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.
--
Please remember to mark this post as answered if this solves your problem.

Conditional formating
 

Try ... Conditional "Formula is"

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

or

=right(Cell,6)="Totals"

HTH ... Kha

"Ryan" wrote:

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.
--
Please remember to mark this post as answered if this solves your problem.

Conditional formating
 

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


Replace @mailinator.com with @tiscali.co.uk


"Ryan" wrote in message
...
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.
--
Please remember to mark this post as answered if this solves your problem.

Conditional formating
 

Thank you very much!!



"Ken" wrote:

Try ... Conditional "Formula is"

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

or

=right(Cell,6)="Totals"

HTH ... Kha

"Ryan" wrote:

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.
--
Please remember to mark this post as answered if this solves your problem.