Conditional Formatting Help

[CTuck]

Hello All...

Is there a way to set a conditional format on one cell based upon the value in a different cell?

thank you!

[K m]

Yes, Click on "Formula is" and enter the formula based on another cell's value

[FDibbins]

CF will accept as many decimal places as any other excel function. i assume you have 3 separate rules, 1 for each of those conditions?

your formulas for each rule should be...
=A1>99.95 green
=AND(A1>99.9,A1<=99.95) yellow
=A1<=99.9 red


and a quick tip. if i am working out a complex-sh CF, i do it in the worksheet 1st, that way i can see easily if my functions are producing the desired result, without having to keep going into Cf and messing around in there

edit: sorry, i thing that belonged to a different post, my machine is acting up