Conditional formatting query

O

oktc

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
 
G

Guest

Hi

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

Andy.
 
Top