| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing property of a box while using if/then statements
I am trying to change a boxes color and use a if statement . For example( if
k70 then change the boxes color red). Is this possiable or is their an easier way. Thanks for any help. Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing property of a box while using if/then statements
Hi Mark,
When you say boxes, do you mean cells? If you do mean cells then look up Conditional Formatting. If this doesn't help then get back to me and let me know the version of xl you are using and I'll provide some further instructions. -- Regards, OssieMac "Mark M" wrote: I am trying to change a boxes color and use a if statement . For example( if k70 then change the boxes color red). Is this possiable or is their an easier way. Thanks for any help. Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manually changing a picture (shape) name property | Excel Discussion (Misc queries) | |||
| changing an activex control property using a macro | Excel Discussion (Misc queries) | |||
| Changing Workbook Property | Excel Programming | |||
| Property Let / Get Statements | Excel Programming | |||
| DisplayAlerts property is not changing to False | Excel Programming | |||
Hybrid Mode
