I am trying to create a conditional format to do the following. If cell B3 is "Executive" and cell C3 is "Contractor" then cell C3 needs to be outlined in red. Both B3 and C3 are populated from data validiation lists. Can you help?! Thanks!

Without knowing what version of Excel your using, the formula would be: =IF(AND(B3="executive",C3="contractor"),"TRUE","FALSE")

MIKE

That was PERFECT, thank you very much! I am in excel 2007, my apologiese, I should have mentioned that. This is my first time posting... will certainly NOT be my last!

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History