Multiple Cell Conditional Formatting in Excel 2013

Closed

ABTILAK Posts 1 Registration date Sunday January 15, 2017 Status Member Last seen January 15, 2017 - Updated by Ambucias on 15/01/17 at 05:20 AM

I have three columns related to the prices of equities. Column A is for the name of individual equity, Column B is for the individual equity price of the previous day, and Column C is for the individual equity price of present day. Column A contains 700 individual equities.
In Column C, all 700 cells will have conditional formatting rule (Format only cells that contain) based on the price in related cell of Column B.
Presently, I am trying to enter the above conditional formatting rule manually for each cell in Column C – which is extremely tedious. The formula for this rule is same for all 700 equities.
My question is – is there any intelligent procedure by which I can enter the above rule in one place/cell and get it entered in all 700 cells of Column C ?
Request your guidance on above.
Regards
ABTILAK
Removed by moderator@yahoo.com

Multiple Cell Conditional Formatting in Excel 2013
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Excel date format dd.mm.yyyy - Guide
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Highlight cell if another cell contains any text ✓ - Excel Forum
Conditional format based on another cell containing text - Excel Forum

Subscribe To Our Newsletter!