Conditional formatting query
 

Hi , Could anyone help me

I am looking for the conditional formatting code that will change the
colour of a value in a cell if another cell contains the text A. I
would then want the formatting to work as a dynamic reference

Many thanks

Conditional formatting query
 

Hi

Set the dialog box in Format/Conditional Formatting to Formula Is and type
in:
=A2="A"
then set your pattern colour.

Andy.

"oktc" wrote in message
oups.com...
Hi , Could anyone help me

I am looking for the conditional formatting code that will change the
colour of a value in a cell if another cell contains the text A. I
would then want the formatting to work as a dynamic reference

Many thanks

Conditional formatting query
 

Thanks Andy, I knew it would be pretty straight forward.

All the best - Tim