Use if with And statment

wcthrill

Board Regular
Joined
Nov 28, 2005
Messages
80
Id like to do a conditional format to a cell. Im comparing 2 stock prices. I need to have the cell chg color if if the high range for the day was higher at least .10 higher than the prev day AND the stock still ended lower than the prev day.

Hope Im explaning myself
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

clayv

New Member
Joined
Sep 18, 2006
Messages
6
Assuming a standard Date, High, Low, Close header in columns A-D (data begins in row 2)...

1. Select column D and then hold down the CNTRL key and select D3 (column should reamin selected)
2. Choose Conditional Formating and use =AND(B3>=1.1*D2,D2>D3) as the formula
3. Pick your formating
4. Click OK
 

Watch MrExcel Video

Forum statistics

Threads
1,113,800
Messages
5,544,347
Members
410,605
Latest member
hinspate
Top