Template Question
I'm making a listing of employees and various detals. For 'better'
readability, I've prepared a template of alteranting rows of white and Light blue and a bunch of headers and saved it as a template in the template folder. Since the listing is an ongoing thing with regular updates, I find the need to sort the entries alphabetically(Usually by name) My problem is, the alternating color arrangement gets all messed up when run the 'sort' function. Is there a way I can keep the templates from getting messed up? -- Bahahahah! |
Hi Logicallystupid,
U can use conditional formatting feature (with formulas) Select the rows and go to format - conditional formatting. In the condition1 rather than "cell value is" choose "formula is" In the adjacent window write the following as it is without the double quotes "=MOD(ROW(),2) =0" In the Format button choose light blue or whatever colors u want. Hit Ok when done. U can have up to 4 possible alternating colors by using a combination of more conditions (use the Add feature) and modifying the above formula to "=MOD(ROW(),3) =0" , "=MOD(ROW(),2) =1" and so on. Search the excel Newsgroup for the last 10 or 11 month's post. One of the regular posters offered some good variations on the above. -- Thanks a lot, Hari India "logicallystupid" wrote in message ... I'm making a listing of employees and various detals. For 'better' readability, I've prepared a template of alteranting rows of white and Light blue and a bunch of headers and saved it as a template in the template folder. Since the listing is an ongoing thing with regular updates, I find the need to sort the entries alphabetically(Usually by name) My problem is, the alternating color arrangement gets all messed up when run the 'sort' function. Is there a way I can keep the templates from getting messed up? -- Bahahahah! |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com