View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Conditional Format

It must work if you apply the same formula for both A2 and B2. If CF formula
already set for B2 is =$H$2<1200 then select range A2:B2 and apply this
formula, for me it worked! (Didn't you forget to place = before the formula?)

Regards,
Stefi

"Dave" wrote:

If a2=Jan followed by b2=316 (green text, this cell already has set
conditional formats). How would I make a2 show the same colour as b2. I
have tried the conditonal format in a2 (Formula is: $h$2<1200) without
success. any ideas?