If Then statement to write text in cell

To insert a cell reference in the condition you must click the cell reference icon (shown at the right end of the box in the third rule definition in my earlier post, then cick the cell to be referenced.

From the appearance of your first rule, I suspect you typed "B9" into the box. Numbers will interpret this as a literal value, not a cell reference.

In th second rule, I suspect you have clicked B10 without first clicking the cell reference icon.

To insert a cell reference, you must first click the cell reference icon, then click the cell to be referenced.

Barry, is the cell reference icon the small square with 42 inside?

Here are the steps Im taking

click on square with 42 inside

click on Show rules

clic on B9 (formula existing inside)

nothing appears in the the conditional formatting blank line or on the screen.

thanks

aha, Im using Numbers 08 and this icon is not there

is there a way to get to it in another way?

what Numbers version r u using?

Thanks Jerry,

I have tried this, but I still cannot get the cell text to turn colors.

Barry showed me a cell icon but it is not showing in Numbers 8

Looking for another way to access the icon.

I did put numbers 08 in the tags section of the first entry...but that was soooo long back in this thread.

Well I downloaded Numbers 09 and started playing around with it

Let me see if I can figure it out from all the help you both have kindly provided.

Either way I'll get back to you both here.

Many thanks Jerry & Barry

Success! so simple in Numbers 09

Thanks Barry & Jerry

awesome upgrade Jerry, got the color conditional formatting done in seconds!

thanks for all your help