use if function to change cell color

[bigdaddy3]

is it possible to use an if function to change a cells color ie if B1= Sandra
then H1=Grey if not Blank

 

[Anne Troy]

Only by use of conditional formatting. See:
http://www.officearticles.com/excel/conditional_formatting_with_formulas_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[bigdaddy3]

Anne, thanks for your help and quick response