alternating format
am using 2007.
Assuming I have a named range called "ColorRange", I need to have something which goes through the range and for each row, evaluates whether or not MOD(row()/2)=0, and if it does, colors it a shade of some sort. I cannot use conditional formatting, because I already have one formatting that needs to occur, and the two together will work in 2007, but this will be run on an earlier version, where there is no checkbox for "stop if true", so that I cannot have both evaluated and both valid. The two things I need to have happen (in case there IS a way to do this with conditional formatting and have it work in earlier Excel versions) is that if the row is odd/even, I need it colored differently. But also, if the number at the end is less than a certain value, I need that cell to be BOLD RED text. I am currently finding that if I have both of the tests on there and one of the tests is met, the other is ignored (because I've made it compatible with older versions). thanks for any help on this one. -- Boris |
alternating format
Use conditional formating. Make the RED condition the 1st condition. The
make the alternatting color requirementt the 2nd and 3rd condition. "BorisS" wrote: am using 2007. Assuming I have a named range called "ColorRange", I need to have something which goes through the range and for each row, evaluates whether or not MOD(row()/2)=0, and if it does, colors it a shade of some sort. I cannot use conditional formatting, because I already have one formatting that needs to occur, and the two together will work in 2007, but this will be run on an earlier version, where there is no checkbox for "stop if true", so that I cannot have both evaluated and both valid. The two things I need to have happen (in case there IS a way to do this with conditional formatting and have it work in earlier Excel versions) is that if the row is odd/even, I need it colored differently. But also, if the number at the end is less than a certain value, I need that cell to be BOLD RED text. I am currently finding that if I have both of the tests on there and one of the tests is met, the other is ignored (because I've made it compatible with older versions). thanks for any help on this one. -- Boris |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com