 |
 | 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 / New Users / April 2008alternating colors as column values change w/ CF
how to alternating colors as column values change. the article below tells me how but I don't want to use any additional helper columns. any ideas? http://www.mvps.org/dmcritchie/excel/condfmt.htm (search with "Color Grouping with alternating colors") I can use conditional formatting on A1:A10 such that if any number falls below 5 the cell goes blue while any cell with value baove 12 is red. All without helper columns. Tell us what you would wish to do.  Signaturewww.stfx.ca/people/bliengme > how to alternating colors as column values change. > the article below tells me how but I don't want to use any additional [quoted text clipped - 3 lines] > http://www.mvps.org/dmcritchie/excel/condfmt.htm (search with "Color > Grouping with alternating colors") col1 cf(bg color) a -- red a -- red(same color above because col1 doesn't change(a(above,current row) b -- blue(change color because col1 changes a(above) to b(current row) b -- blue(same color above because col1 doesn't change(b(above,current row) b -- blue(same color above because col1 doesn't change(b(above,current row) c -- red ... c -- red ... a -- blue ... a -- blue ... clear? Bernard Liengme 쓴 글: > I can use conditional formatting on A1:A10 such that if any number falls > below 5 the cell goes blue while any cell with value baove 12 is red. All > without helper columns. > Tell us what you would wish to do. Experiment with: Formula Is =AND(A2=A1,A2=A3) format Blue best wishes > col1 cf(bg color) > a -- red [quoted text clipped - 18 lines] >> without helper columns. >> Tell us what you would wish to do. doesn't work at all. Bernard Liengme 쓴 글: > Experiment with: > Formula Is =AND(A2=A1,A2=A3) format Blue [quoted text clipped - 22 lines] >>> without helper columns. >>> Tell us what you would wish to do. |
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.