Conditional formatting on named text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a named cell called AltFundingQuote.
This cell is populated with a drop down box with the text options
of Cost Plus, ASO, or Prospective.

When setting a conditional format for the following - it doesn't work.
I'm trying to only display the text if the condition is true by using a
white font and white background in the formatting.

=OR(AltFundingQuote<>"Cost Plus",AltFundingQuote<>"ASO")

What am I doing wrong?
 
Sharon,

You say it doesn't work, but you don't say in what way. And I can only
guess what your objective is. The statement
=OR(AltFundingQuote<>"Cost Plus",AltFundingQuote<>"ASO")
will always be TRUE, so you'll always get the conditional formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top