View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 27
Default Conditional Format

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?