| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a cell color....
Hi,
Can someone help me how can I change a cell color using the"IF" command??? Thank you, Shaul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a cell color....
In the worksheet, you can't
in a vba routine (not used as a function in a worksheet) if condition then activeCell.Interior.ColorIndex = 5 End if -- regards, Tom Ogilvy "Shaul" wrote in message ... Hi, Can someone help me how can I change a cell color using the"IF" command??? Thank you, Shaul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a cell color....
Shaul,
In the worksheet you can do this with Conditional Formatting. -- sb "Shaul" wrote in message ... Hi, Can someone help me how can I change a cell color using the"IF" command??? Thank you, Shaul |
| 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 Cell Color | Excel Discussion (Misc queries) | |||
| Changing color of cell | New Users to Excel | |||
| Changing cell color | Excel Worksheet Functions | |||
Hybrid Mode
