How do I set up for greater than 3 formats in excel?
 

I have a spreadsheet resulting from an SQL query which produces a collumn of
'Status' results. I want to define the colour of each row in my spreadsheet
according to the status.

I have 8 possible 'Status' results and wish to apply 4 colour separations.

Any suggestions?

How do I set up for greater than 3 formats in excel?
 

Sure - Format them all to one colour, or just use the default, and then use
CF to get you 3 others - That gives you 4 in total.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"Stephen" wrote:

I have a spreadsheet resulting from an SQL query which produces a collumn of
'Status' results. I want to define the colour of each row in my spreadsheet
according to the status.

I have 8 possible 'Status' results and wish to apply 4 colour separations.

Any suggestions?