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.

"carl" wrote:

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.