Syntax help please

[Paul Hyett]

I have a conditional format set up to flag where an item in a list
matches one in a specified range :

=OR(EXACT(B54,B$2:B$50))

This works, but it would be better if it could flag items that *didn't*
match ones in the specified range - but I'm not sure of exactly how to
modify the above formula to do so?

(Excel 2003)

TIA.

 

[Paul Hyett]

if understood correct this example in attachment could be helpfull ?

[ A MIME application / vnd.openxmlformats-officedocument.spreadsheetml.sheet part was included here. ]

It probably would have, if only I could have opened it...

 

[GS]

After serious thinking Paul Hyett wrote :

if understood correct this example in attachment could be helpfull ?

[ A MIME application / vnd.openxmlformats-officedocument.spreadsheetml.sheet
part was included here. ]

It probably would have, if only I could have opened it...

Did you try saving it first?

 

[isabelle]

hi Paul


select B2:B50
then doing the mfc with 2 conditions,

condition1
=EXACT($B$54,B2) format: blue

condition2
=NOT(EXACT($B$54,B2)) format: gray


--
isabelle




Le 2012-01-19 11:59, Paul Hyett a écrit :

if understood correct this example in attachment could be helpfull ?

[ A MIME application / vnd.openxmlformats-officedocument.spreadsheetml.sheet part was included here. ]

It probably would have, if only I could have opened it...

 

[Paul Hyett]

After serious thinking Paul Hyett wrote :

if understood correct this example in attachment could be helpfull ?

[ A MIME application /
vnd.openxmlformats-officedocument.spreadsheetml.sheet part was
included here. ]

It probably would have, if only I could have opened it...

Did you try saving it first?
Yes.

 

[Paul Hyett]

hi Paul


select B2:B50
then doing the mfc with 2 conditions,

condition1
=EXACT($B$54,B2) format: blue

condition2
=NOT(EXACT($B$54,B2)) format: gray

Thanks - I'll try this.

 

[mag]

and in accordance with original question, conditional format set up now
can be done based on real value in cell

 

[Paul Hyett]

Thanks - I'll try this.

Great, it worked - thank you.