Conditional Formatting help required
Thanks, Biff.
Substring (could be several differnet values). Isn't it a pitty we cannot
standardize functions across VBA so that INSTR( ) from Access would work in
Excel?
I'll give that a try.
--
Email address is not valid.
Please reply to newsgroup only.
"T. Valko" wrote:
If the cell contains "PARTIAL", "GOOD", or "MEDIUM",
Are those words a *substring* or are they the only string?
If they're the only string:
=OR(D4="PARTIAL",D4="GOOD",D4="MEDIUM")
If those words are a *substring*:
=OR(ISNUMBER(SEARCH("partial",D4)),ISNUMBER(SEARCH (F2,"good")),ISNUMBER(SEARCH(F3,"medium")))
Biff
"Dale Fye" wrote in message
...
I am trying to format the background color of a cell based on text in that
cell.
If the cell contains "EXCELLENT", I want to color the background green
(works great).
If the cell contains "PARTIAL", "GOOD", or "MEDIUM", I want to color it
yellow. I've tried putting the following in a Cell, but it just returns a
#Value error.
=OR(SEARCH("MEDIUM", D4) 0, SEARCH("PARTIAL",D4)0,Search("GOOD", D4)0)
When I only put one of these critiera in the OR function, it returns the
proper logical value. Any ideas what I am doing wrong?
Actually, I tested =SEARCH("GOOD", D4) and =Search("PARTIAL", D4)
individually as the cell forumla and they each returned a #Value! result.
Any ideas how to make this work?
--
Email address is not valid.
Please reply to newsgroup only.
|