change text color in col A according to # value in other columns?

[charitydc]

I am wanting to auto Change the text color from red to black in Col A rows 2 through 33 based on the value of Columns B, C, E and G rows 2 - 33 being greater than 0.

How do I go about doing this? I don't want this format in any other cells/rows except the ones stated above.

I'm not excel savy so please explain in detail lol.

Thanks in advance!

[Domski]

Hi,

Do you mean the text colour should be black if all the adjacent values are greater than 0?

A sample workbook may help to illustrate your problem better.

Dom

[Marcol]

I have read your post several different ways!!!

You would do best to post a sample workbook showing your Sheet Layout and the Cells you need the formatting.(Change these cells manually)

It should clearly illustrate your problem and not contain any sensitive data.

Cheers

[charitydc]

Hi,

Do you mean the text colour should be black if all the adjacent values are greater than 0?

A sample workbook may help to illustrate your problem better.

Dom

Yes i think that's what I mean lol. I have A2 - A33 font color set at red so when the value of B2-B33 or C2 - C33 or E2 - E33 or G2 - 33 is changed to a number greater than 0, I want the text in that corresponding cell in col A to turn black.

I have attatched a sample... the text in col A and the greater than 0's would be in the GREEN columns. I'm just confusing myself even more here LOL!

[Marcol]

Try this

Conditional formatting

Formula is:=
=MAX($B1:$H1)>0

Applies to:=
=$A:$H

Format.......
Font > Color > Automatic

Hope this helps

[charitydc]

Try this

Conditional formatting

Formula is:=
=MAX($B1:$H1)>0

Applies to:=
=$A:$H

Format.......
Font > Color > Automatic

Hope this helps

YES this is exactly what I want with the exception of NOT including columns d2-33, f2-33 and h2-33. If it has to include those cells then thats fine, i'll manage with that lol.

I have been trying to get to where i do this lol, I get to conditional formatting then i'm stumped as to where to go to next. Highlight cells rules? I don't know excel that well so i need more in depth guidance lol. Lead me oh smart leader LOL

[TechRetard]

YES this is exactly what I want with the exception of NOT including columns d2-33, f2-33 and h2-33. If it has to include those cells then thats fine, i'll manage with that lol.

I have been trying to get to where i do this lol, I get to conditional formatting then i'm stumped as to where to go to next. Highlight cells rules? I don't know excel that well so i need more in depth guidance lol. Lead me oh smart leader LOL

To use conditional formatting, highlight the cells you want formatted and select Format --> Conditional Formatting or in 2007 use the Conditional Formatting drop down on the ribbon, select "new rule", and then "Use a formula to determine which cells to format"

You could re-arrange the columns so B, C, E, G are the first four, then just change the conditional formula to: =MAX($B1:$E1) or you could just use the formula =OR(MAX($B2:$C2)>0,E2>0,G2>0)

[Marcol]

You don't say what version you need this to work with, I assume by the file format it is 2007 or later.

Try this variation

Conditional Formatting > Manage Rules
1/. Select and then Delete the old rule in the dialogue list

2/. Click New Rule then select "Use a formula to determine which cells to format"

in the first textbox
Formula is:=

Please Login or Register  to view this content.

Click Format.......
Select tab Font > Color > Automatic press Okay

Press Okay again

Finally in
Applies to:=

Please Login or Register  to view this content.

You can have this automatically filled if you select $A$2:$A$33 at the beginning, but always check it, and if you change it, recheck the formula.

Excel can sometimes be to smart for it's own good, and will try to change the formula references to what it thinks they should be.
(It can take a bit of persistance to learn how Excel automatically changes things)

Hope this helps

I have amended this workbook.

Tips:-
1/. Add a location to your profile, it helps with prioritising replies according to time zones and any possible language interpretation problems.

2/. Add the version of Excel you are using there are significant differences between them and it helps to know when answering problems.

[charitydc]

I will try these and get back with you. I forgot to add it's for excel 2010. and im in Florida. central time.

I will post back once I try these with my results.

Thank you again! Love this forum!

[charitydc]

AWESOME AWESOME AWESOME!!!! You guys are the greatest!!!! It works just the way I wanted it to. Thank you sooooo much! Very much appreciated! This will make my work a little more easier lol.