G Guest Sep 16, 2005 #1 is it possible to use an if function to change a cells color ie if B1= Sandra then H1=Grey if not Blank
is it possible to use an if function to change a cells color ie if B1= Sandra then H1=Grey if not Blank
A Anne Troy Sep 16, 2005 #2 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
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