Conditional Formating

C

carl

My data table looks like this

A B C D E F
QQQQ 8.52% 3.31% 20.65% 33.18% 16.11% 18.23%
AAPL 3.04% 4.59% 24.84% 27.91% 18.27% 21.35%
SPY 4.34% 5.00% 47.32% 19.28% 4.37% 19.70%
..SPX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00%
IWM 3.49% 2.33% 22.51% 16.43% 50.38% 4.87%
XLF 5.21% 1.10% 14.86% 53.95% 23.33% 1.55%
AMGN 4.59% 2.46% 64.98% 20.41% 3.81% 3.76%
..RUT 25.90% 1.96% 28.57% 40.44% 1.33% 1.80%
MO 25.68% 5.59% 14.62% 35.64% 11.59% 6.89%
..VIX 0.00% 0.00% 100.00% 0.00% 0.00% 0.00%
GE 2.89% 5.60% 15.66% 52.26% 12.27% 11.32


Can I use the Conditional Format to highlight the rows were the value in
ColB is less than 3% and any other value in the row is greater than 50% ?

Thank you in advance.
 
D

Darrilyn

Yes you can. Highlight all of the data and on condition one you will choose
formula is and type in =$B2<3 and then click add and on condition two you
will click cell value is and choose greater than or equal too or just greater
than and a drop down box will appear and click the value that you want.
Choose your formatting from the format box and it should work.
 
C

carl

Thanks. This does not work. I probably did not explain my problem well enough.

I need the Conditional Format to highlight only the rows were the value in
ColB is less than 3% and any other value in the row is greater than 50% ?

Seems like it would be an IF/AND problem ?

Any thoughts ?
 
B

Beege

carl wrote:

Highlight your data.
I'm going to assume your column B is in Excel column C


Conditional format
Formula is =AND($D2>=0.03,MAX($C2:$H2)>=0.5)
Format as desired

Doe this work for you?

Beege
 
B

Beege

carl said:
Thanks. This does not work. I probably did not explain my problem well enough.

I need the Conditional Format to highlight only the rows were the value in
ColB is less than 3% and any other value in the row is greater than 50% ?

Seems like it would be an IF/AND problem ?

Any thoughts ?

If your column B is in excel column C and your date is from B2 to H12, then

Try C/F

Formula is =AND($C2>=0.03,MAX($B2:$H2)>=0.5)

Format as desired.

Helps?

Beege
 
Top