| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function to change color of cell? | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| color of a cell within a nested if function | Excel Discussion (Misc queries) | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| Color change in cell when > 49.99 | Excel Discussion (Misc queries) | |||
Hybrid Mode
