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.

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.

solution for Excel =< 2003

select C1

then Format-Conditional formatting

Formula Is-AND(C1<5%,OR(A1<"SPX";A1<"MER"))

and choose yr formatting

then copy down and PasteSpecial as Formats


for Excel 2007:

click COnditional Formatting on the taskbar

-select New Rule-Use Formula_insert the am formula

select required formatting

Use a CF formula of

=AND(A2<"SPX",A2<"MER",C2<5%)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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.