andy617
Newbie
Joined: 07 Apr 2005
Posts: 2
Location: england
|
 Posted: Jan 11th, 2006 11:26 AM Post subject: colouring a cell... |
 |
|
I would like a cell from a range to change colour whenever some text is entered into it.
For example, if I type in a date or text like 'yes or no' into a cell ranging from F4:F44 then it will turn the cell colour yellow.
I've tried to use the conditional formatting function but this can only be used 3 times and I need to use it more than 3.
Can this be done using VBA? Could anyone offer any help on this.
Thanks |
|
