Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set font color depending on value Range
greetings,
simple question (I think). Many thanks for any input on this. Is there a way using Range to set cells to either red or green depending on whether they are 5% (red), or less (green). I'm on office 2003. I'm currently doing this using the looping logic and that's pretty slow. I'm hoping the range option will be faster. If Excel.Range(ActiveCell.Offset(1, 110), _ ActiveCell.Offset(1, 1)).Value = 0.05 Then Excel.Range(ActiveCell.Offset(1, 110), _ ActiveCell.Offset(1, 110)).Font.ColorIndex = 3 Else Excel.Range(ActiveCell.Offset(1, 110), _ ActiveCell.Offset(1, 110)).Font.ColorIndex = 10 End If regards, CG |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set font color depending on value Range
Have you thought of using conditional formatting as built into Excel?
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LetMeDoIt" wrote in message ... greetings, simple question (I think). Many thanks for any input on this. Is there a way using Range to set cells to either red or green depending on whether they are 5% (red), or less (green). I'm on office 2003. I'm currently doing this using the looping logic and that's pretty slow. I'm hoping the range option will be faster. If Excel.Range(ActiveCell.Offset(1, 110), _ ActiveCell.Offset(1, 1)).Value = 0.05 Then Excel.Range(ActiveCell.Offset(1, 110), _ ActiveCell.Offset(1, 110)).Font.ColorIndex = 3 Else Excel.Range(ActiveCell.Offset(1, 110), _ ActiveCell.Offset(1, 110)).Font.ColorIndex = 10 End If regards, CG |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
set font color depending on value Range
hhhmmm not sure how conditional setup would be setup in VBA. The
sheets I need to do this are dynamically created. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
set font color depending on value Range
thanks for the tip, I looked up conditional formatting. I think I'm
ok from here. regards, CG |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
set font color depending on value Range
This might help
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LetMeDoIt" wrote in message ... thanks for the tip, I looked up conditional formatting. I think I'm ok from here. regards, CG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font color depending on cell value | Excel Worksheet Functions | |||
Extracting font color within a range | Excel Programming | |||
conditional depending on font color help? | Excel Programming | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
font color depending upon value possible? | Excel Programming |