CF/ Formula Is/ =AND(C2<5%,A2<"SPX",A2<"MER")
--
David Biddulph

"carl" wrote in message
...
My table looks like this:

ColA ColB ColC
SPY 2% 5%
QQQQ 9% 7%
SPX 0% 0%
IWM 2% 7%
XLF 10% 5%
BSC 6% 1%
AAPL 16% 3%
C 6% 6%
DIA 1% 3%
EEM 2% 0%
BAC 4% 4%
GE 26% 4%
JPM 2% 5%
SMH 29% 4%
MER 6% 8%
RUT 3% 2%
RIMM 1% 7%
QCOM 1% 6%
INTC 35% 7%
CSCO 5% 8%


I would like the cells in ColC to be "highlighted" if the value is less
than
5% and the value in ColA is not equal to SPX or MER.


Thank you in advance.