Excel 2007 Conditional Formatting Gripe

[AC5FF]

I couldn't stand it any longer and I had to vent before I threw my monitor across the room!

I've not had to mess with conditional formatting since our systems here were upgraded to Office 2007... But trying to get a conditional formatting to work now is just aggrivating me to no end!

I've done some browsing and found examples, but I can't get anything to work like I need!! Grrr

Will post the problem here... Maybe someone can explain it better than other websites I have visited.. Should be a very simple formatting issue, and it WAS prior to 2007!!

Okay; cell N3 just has text in it. However, I want to base the text color off of a value in cell J14. If the value in J14 is <60 the font will be red. If it is between 60 and 85 the font will be yellow, and if it is >85 the font will be green.

I just don't get it!! I have been using the "Use a Formula" rule type, and will type in "J14<60" for one condition, "60<J14<85" for another, and "J14>85" for the third. Yet nothing happens. (BTW: Current value in J14 is 88.14)


Just one more vent..
AAAAAARRRRGGGGHHHHHHHHHHHHHH!!!!!

 

[AC5FF]

BTW: Something I've not found in my reading yet is what the "Stop if True" checkbox in the rules manager is doing...

 

[AC5FF]

Sometimes all you need to do is vent!! LOL

I could have sworn I tried it, but I think it was a combination of faults on entry.

Needs to have the "=" in the front.
Also needs to have "$" in front of the Row and Column (i.e. $J$14)
Can't use 65<J14<85. This needs entered as =AND($J$14>65, $J$14<85)

Venting helped. Thx! LoL

 

[Brianwarnock]

LOL
As I read post 1 I thought, he needs an = and an AND there, then I got to post 3 and it was solved, just shows that you cant beat a good rant.

Brian

 

[AC5FF]

LoL.. Thx Brian!