View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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