Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |