Can someone point me to a source that will tell me what the colour numbers are
for fonts?

I have a spreadsheet in which I add data from my firewall log daily. At the
end of the week I sort the worksheet into IP address order and then review the
data making the row font colours in columns 1-6 red if more than 7 per week from
an ISP, orange if less than 7 per week. Some rows are left black if there is no
data on the ISP.

After the analysis I sort the worksheet back into date order using a macro that
also colours columns 1-6 colour 48 (dark grey) if the font colour in column 1 is
automatic.

I thought that the colour numbers would be say black is 0 and the other font
colours go up by 1 working from left to right but this doesn't seem to be the
case judging on dark grey being colour 48.

Is there a reference that tells me what the colour numbers are for other font
colours in the drop down list?
--

Cheers . . . JC

See:

http://www.mvps.org/dmcritchie/excel/colors.htm
--
Gary's Student


"JC" wrote:

Can someone point me to a source that will tell me what the colour numbers are
for fonts?

I have a spreadsheet in which I add data from my firewall log daily. At the
end of the week I sort the worksheet into IP address order and then review the
data making the row font colours in columns 1-6 red if more than 7 per week from
an ISP, orange if less than 7 per week. Some rows are left black if there is no
data on the ISP.

After the analysis I sort the worksheet back into date order using a macro that
also colours columns 1-6 colour 48 (dark grey) if the font colour in column 1 is
automatic.

I thought that the colour numbers would be say black is 0 and the other font
colours go up by 1 working from left to right but this doesn't seem to be the
case judging on dark grey being colour 48.

Is there a reference that tells me what the colour numbers are for other font
colours in the drop down list?
--

Cheers . . . JC

Many thanks. Problem solved.

JC

On Sat, 7 Oct 2006 03:52:01 -0700, Gary''s Student
wrote:

See:

http://www.mvps.org/dmcritchie/excel/colors.htm