 |
 | 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 / March 2008copying conditional formatting
Hi, I have a row of 5 cells. I want to format them so that when two of the 5 cells are >0 the whole set of cells change color. I used the countif function to do this and it works fine. I now want to copy this conditional format for all 5 cells down the other 50 rows. I have tried the usual paste, paste special, but these do not work. Any help would be appreciated Thank you David Williams Try the format painter (brush icon) Select the row of 5 cells with CF Double click on the format painter Then just "brush" over (select) the 50 rows below Press Esc when done  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hi, > I have a row of 5 cells. I want to format them so that when two of the 5 [quoted text clipped - 9 lines] > > David Williams Thanks, both systems work brilliant > Try the format painter (brush icon) > Select the row of 5 cells with CF [quoted text clipped - 14 lines] > > > > David Williams Welcome, thanks for posting back. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Thanks, both systems work brilliant By default, conditional formatting uses absolute values ($). If you want to copy down rows, just remove the $ in front of the row number in your formulas. $A$1 -> $A1 > Hi, > I have a row of 5 cells. I want to format them so that when two of the 5 [quoted text clipped - 9 lines] > > David Williams Thanks to both of you. Both systems work. Thanks again > By default, conditional formatting uses absolute values ($). If you want to > copy down rows, just remove the $ in front of the row number in your formulas. [quoted text clipped - 14 lines] > > > > David Williams |
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.