LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default Excel 2002: Conditional format multiband colors

Hi,

Thanks for your formula.

It works.

Best Regards

Low
--
A36B58K641


"MyVeryOwnSelf" wrote:

I need to conditional format a table with 3 rotating colors of yellow,
green and blue. The condition to change the color is when the code
changes.
A B C D
1 B12 XXX XXX Yellow
2 B12
3 C26 Green
4 C26
5 C26
6 D52 Blue
7 E27 Yellow
8 E27
9 E27
10 E27
11 G49 Green
12 G49
13 H96 Blue

May I know what are the formulas 1, 2 and 3 in order for me to get the
result ?


One way is to use a helper column.

For example, start by putting 0 (zero) in E1.

Then put something like this in E2
=IF(A2="",-1,IF(A2=A1,E1,MOD(E1+1,3)))
and copy down as far as the list might ever reach.

This gives numbers 0, 1, and 2 for the three different row colors. I put in
the -1 presuming that rows after the end of the list are supposed to have
no color.

The helper column can be hidden (or kept out of the print range) to avoid
clutter.

Modify to suit.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002: How to conditional format band of colors ? Mr. Low Excel Discussion (Misc queries) 2 November 4th 08 01:45 PM
colors and conditional format - greater than, less than Michele Excel Discussion (Misc queries) 5 October 1st 07 10:38 PM
Excel 2002 : How to conditional format the Sub Total Table ? Mr. Low Excel Discussion (Misc queries) 4 September 18th 07 03:06 PM
Excel 2002: How to conditional format a row of cells ? Mr. Low Excel Discussion (Misc queries) 2 September 18th 07 03:04 PM
Cell colors on conditional format tankerman Excel Discussion (Misc queries) 6 March 2nd 07 06:31 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"