Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
conditional formating?? | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions |