|
Posted to microsoft.public.excel.misc
|
|
|
Font colour numbers
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
|