| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to determine colour of text in rows
Hi,
What would be the macro commands to determine the colour of the text in a cell in a Microsoft 97 spreadsheet? Any help would be much appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to determine colour of text in rows
Activecell.Font.ColorIndex
you can get the colours by looking at the ColorIndex Property in VBA Help(3 is red for instance) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Hi, What would be the macro commands to determine the colour of the text in a cell in a Microsoft 97 spreadsheet? Any help would be much appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to determine colour of text in rows
Thanks... again.
On Mon, 12 Jan 2004 23:01:56 -0000, "Bob Phillips" wrote: Activecell.Font.ColorIndex you can get the colours by looking at the ColorIndex Property in VBA Help(3 is red for instance) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Hi, What would be the macro commands to determine the colour of the text in a cell in a Microsoft 97 spreadsheet? Any help would be much appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colour rows alternating colour | Excel Discussion (Misc queries) | |||
| Using a formula to determine variable rows in Chart | Charts and Charting in Excel | |||
| determine cell colour | Excel Discussion (Misc queries) | |||
| Determine number of rows meeting a condition | Excel Discussion (Misc queries) | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Linear Mode
