Conditional Format

[carl]

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.

 

[Jarek Kujawa]

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

 

[Bob Phillips]

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)