View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vanessa Simmonds Vanessa Simmonds is offline
external usenet poster
 
Posts: 17
Default Conditional Formatting vs Formulas

Good Afternoon,

Can someone help me, please?

I have a list of code in Worksheet 2. I want to create a conditonal
formatting rule on worksheet 2 that will look for the code on Worksheet 1
Column 1 and if worksheet 1 column 2 equal active, the cell on worksheet 2
will turn green.

Is that possible using conditional formatting tool?

If not, is there any other way I could do it?

Thank you very much for your help.

Vanessa Simmonds