ExcelBanter - use if function to change cell color

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use if function to change cell color (https://www.excelbanter.com/excel-worksheet-functions/45720-use-if-function-change-cell-color.html)

bigdaddy3

use if function to change cell color

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

Anne Troy

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

"bigdaddy3" wrote in message
...
is it possible to use an if function to change a cells color ie if B1=
Sandra
then H1=Grey if not Blank
--
BD3

bigdaddy3

Anne, thanks for your help and quick response
--
BD3

"Anne Troy" wrote:

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

"bigdaddy3" wrote in message
...
is it possible to use an if function to change a cells color ie if B1=
Sandra
then H1=Grey if not Blank
--
BD3

All times are GMT +1. The time now is 06:35 PM.