Conditional Formatting with OR

[RJB78]

Hello. Looking to do conditional formatting for a cell (A5) to turn color when:

E5="CP","CP-G","CP-GI","CP-D","CP-ETF","CP-G/D","CP-G/GI","CP-G/ETF","CP-D/GI","CP-D/ETF","CP-GI/ETF")

I was using 'use a formula to determine which cells to format" and using an OR function but couldn't get it to work.

Thanks in advance.

 

[63falcondude]

Try this:

=OR(E5={"CP","CP-G","CP-GI","CP-D","CP-ETF","CP-G/D","CP-G/GI","CP-G/ETF","CP-D/GI","CP-D/ETF","CP-GI/ETF"})

 

[RJB78]

It says "You may not use reference operators (such as unions, intersections, and ranges) or array constants for Conditional Formatting criteria"

 

[63falcondude]

It says "You may not use reference operators (such as unions, intersections, and ranges) or array constants for Conditional Formatting criteria"

Aah that's unfortunate... I guess you will have to change the formula to something of the form =OR(E5="CP",E5="CP-GI",E5=...)

 

[Aladin Akyurek]

Define CFlist in FORMULAS | Name Manager as referring to:

={"CP","CP-G","CP-GI","CP-D","CP-ETF","CP-G/D","CP-G/GI","CP-G/ETF","CP-D/GI","CP-D/ETF","CP-GI/ETF"}

Now invoke Conditional Formatting the following formula:

=MATCH($E5,CFlist,0)

And choose for the desired formatting.

 

[RJB78]

Yes. That worked. Thank you.

 

[Aladin Akyurek]

Yes. That worked. Thank you.

You are welcome.