Change color of text in excell using IF statement

K

Krudonix

Well-Known Member
Joined
Jan 13, 2006
Messages
148
Reaction score
0
Hey

Im tryin to change a color of text in certain cells to either green or red depending on certain conditions.

I cant use conditional format as i got a ton of different conditions so I have to use IF statements.

any1 know how to do this ?
 
not sure if its VBA, aint that a macro ?
isnt there a way to put formulae inside the cellblock? like u would do a normal math formulae ?

basically i got 2 columns
1st is target
2nd is current

if the value in the current column is less than target column it must go red and if its same or greater it must go green.
 
Use the conditional formatting menu option, or alternatively ASAP Utilities has some kind of conditional formatting functionality.
 
Krudonix said:
not sure if its VBA, aint that a macro ?
isnt there a way to put formulae inside the cellblock? like u would do a normal math formulae ?

basically i got 2 columns
1st is target
2nd is current

if the value in the current column is less than target column it must go red and if its same or greater it must go green.
Click to expand...

basically you want (and this is pseudo code!):

if (C1 < D1) {C1.color = RED}

?
 
would love to use some thing like

if (C1 < D1) {C1.color = RED}

?

conditional formatting is not a solution .. i have to do it on every row .. unless im doing something wrong
 
Krudonix said:
would love to use some thing like

if (C1 < D1) {C1.color = RED}

?

conditional formatting is not a solution .. i have to do it on every row .. unless im doing something wrong
Click to expand...

?

Seems like you should select the whole block (all affected rows) and apply the conditional formatting in one step? Or am I missing something? If you only have those 2 conditions, then this should work.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X