Orange fill if certain text found..

[themadtux]

My question is this, I have a spreadsheet where I have cells that utilize conditional formatting in that if a certain cell is filled with text it will color a certain cell green. The colored cell is using [=ISTEXT(F29)] as the condition. Now the one thing I'd like to do is if the cell, for example, F29 has text in it it will color cell B13 green, but if the text in cell F29 is just the word "SPARE" it will fill cell B13 the color orange. How would I go about doing this? I've tried using conditional formatting and having 2 seperate conditions but can't seem to figure it out, no matter what text I put in the cell it will color it green.

I hope this question is clear enough

Thanks,

-Jason

[NBVC]

Add a first condition..

=F29="SPARE" and format to Orange,

Then the next condition is your other formula..

In the conditional Rules manager dialogue, check the stop if true checkbox

[themadtux]

Awesome that worked! I figured it was something easy that a veteran could help with.

Thanks again!

-Jason