| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
color of text
Tammy
What do you want if number is exactly 50 or 50000? FormatConditional FormattingCell Value is: between 50(or 50.1) and 50000(or 49999.9) depending upon the answer to first question. Gord Dibben MS Excel MVP On Tue, 27 Feb 2007 12:23:06 -0800, Tammy wrote: Is there a way (macro or vb code) to make a text appear a certain color. For example, if the number in the cells a1:aa65000 50 but <50000 then color them red? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| Shortcut for FILL COLOR and COLOR TEXT | Excel Discussion (Misc queries) | |||
Hybrid Mode
