| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour changingusing VBE
Sorry i might be a bit stupid on here but i cant seem to make it work
"Mike" wrote: colourindex will do that Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If mycell.Value = whatever Then colourindex = 3 End Sub would change the cell to red if true "Stan Halls" wrote: is it possable to change the cell colour / text depending on the value of the cell.... using VBE rather than conditional formatting |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font colour numbers | Excel Discussion (Misc queries) | |||
| alternating cell colour | New Users to Excel | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Problems with Colour Printing | Excel Discussion (Misc queries) | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Threaded Mode
