 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Conditional Formatting
Is it possible to apply a conditional formatting in cases where each value in column P exceeds the adjacent value in column D. I have several hundred rows and would like to do this without visiting each individual cell in column P. Apply it to one cell, then select the entire column or just the cells you want. Make sure the first cell is part of the selection. Go to the Conditional Formatting menu and it should display the custom format from that first cell. Click OK and it will apply it to the selected cells. Or, copy/paste formats.  SignatureTim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility > Is it possible to apply a conditional formatting in cases where each value > in [quoted text clipped - 3 lines] > each > individual cell in column P. Where in the Conditional Formatting menu should I see the custom formatting applied to the first cell? I wonder if this feature was left out of Excel 2007. > Apply it to one cell, then select the entire column or just the cells you > want. Make sure the first cell is part of the selection. Go to the [quoted text clipped - 10 lines] > > each > > individual cell in column P. Looks like conditional formatting is drastically modified in 2007. Add to the "Applies To" range reference. SignatureTim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility > Where in the Conditional Formatting menu should I see the custom > formatting [quoted text clipped - 16 lines] >> > each >> > individual cell in column P. Yes. Select your range of cells in P, with P2 active, then CF/ Cell Value Is/ Greater Than/ =D2 and Format as appropriate. Otherwise apply the format to P2 and use Format Paint to copy down Or, as a third optionn, Copy from P2 and Paste Special/ Format -- David Biddulph > Is it possible to apply a conditional formatting in cases where each value > in [quoted text clipped - 3 lines] > each > individual cell in column P. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.