| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I color code comments in cells on Excel spreadsheet?
Excel 2007 - How do I color code comments on spreadsheets? green for text,
red for amounts, etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I color code comments in cells on Excel spreadsheet?
Comments as in Insert Comment or just in-cell comments.
For the latter you could use in CFNew RuleUse a formula =ISNUMBER(cellref) or =ISTEXT(cellref) I don't know what "etc." encompasses so can't help there. Gord Dibben MS Excel MVP On Sat, 26 Sep 2009 14:57:01 -0700, LBH wrote: Excel 2007 - How do I color code comments on spreadsheets? green for text, red for amounts, etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAN I COLOR CODE CELLS CONDITIONALLY, SIMILAR TO A FORMULA? | Excel Discussion (Misc queries) | |||
| How to color automatically color code sums in cells | Charts and Charting in Excel | |||
| Color code cells | Excel Worksheet Functions | |||
| How to pull cells from other worksheets including color/comments? | Excel Worksheet Functions | |||
| Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
Linear Mode
