Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color
How can I change a cell color by using an IF statement
Lets say my value is true, how would I format the equation to change my cell color? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color
You can use Conditional Formatting from the Format menu to do
this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David" wrote in message ... How can I change a cell color by using an IF statement Lets say my value is true, how would I format the equation to change my cell color? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color
If you are using excel then there is an option as
Conditional Formating(see excel's help). Programatically: If value = true then cells(addess).interior.colorindex=5 you can play with this -----Original Message----- How can I change a cell color by using an IF statement Lets say my value is true, how would I format the equation to change my cell color? Thanks in advance . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the color of a cell based on the color of another cell. | Excel Discussion (Misc queries) | |||
Changing cell color by value | Excel Worksheet Functions | |||
Changing color of cell | New Users to Excel | |||
Changing Cell Color | Excel Worksheet Functions | |||
Changing a cell color.... | Excel Programming |