Uh, no - the formula I gave resulted in “Not Five” - not “FALSE”. I specifically said “If you leave off the “Not Five” part, it results in “FALSE””.
Let me add a question of my own. Is is possible to set up conditional formatting to check a different cell and format appropriately? For instance, format cell D5 with a green background if cell X100 contains “yes” or another designated string.
Yes
Type yes into cell x100
click on cell D5
click conditional formatting -> New Rule
click “Use a formula to determine which cells to format”
in the formula box that pops up type:
=X100=“yes”
Click the format button
Click the fill tab and select green, then click OK on the format box and click OK again at the new formatting rule box
done
Occasionally, Excel will screw up the necessary quotes in the rule when you do things like this. If it doesn’t work, highlight the cell and click on manage rules, select your rule and play with the way the quotes are shown in the rule - this just takes some tinkering and getting used to. In this scenario, however, it should not be necessary. It usually only pops up with more complicated formulas.
Neither of which answered the original question.
No, it didn’t. But as explained in the post, it was another way to look at the formula to try to understand it, rather than just C&P it from your post.
Why is offering GB an explanation of the ins and outs of the formula provided such a threat to you? Jeez, lighten up.
Thank you
Here is a new thread on another board where this issue is discussed.
Yes–instead of using a value, you select “Formula.” Then your formula for formatting D5 is something like
=X100=“yes”
The user interface for conditional formatting changed a bit going from 2003 to 2007 so to provide more detail I would need to know which version you’re using.
Okay, new issue with this spreadsheet (and my boss’s crazy demands!!!) … instead of selecting Yes or No, my boss would like for the client to select either a green, yellow, or red light from a drop down box. He saw these options in the Icon Sets under conditional formatting.
Am I able to do this in Excel?
I’ve googled everything I can about icon sets and don’t think that they can be based on text. I’d like to avoid VB if at all possible.
Thanks again for any input!
Holy christ… 
I don’t think you can. But you can have them select from the words “red” “yellow” and “green”, and have conditional formatting change that to “red background/red text” which will result in a completely red cell. Same for yellow and green, of course.
You cannot have your client choose from these buttons - they are there for you to use when you do conditional formatting.
It is possible to have your client use “Radio Buttons” which, in theory, could be colored - but you are deep into Macro land at this point.
I know, right?!!!
I think I’ve resolved the issue, though. I told my boss that I don’t think it’s possible to use icon sets with text and he seems satisfied with that answer … for now … 
Thanks for your response!
And that’s what I wanted to avoid, if at all possible. He seems content with the finished product now. He saw those shiny icon sets, though, and couldn’t resist!
Does your boss have pointy hair? 