Hi Wazooli

No, not with a function ( only with code )
Or you can use CF, see Debra's site for examples
http://www.contextures.com/xlCondFormat01.html

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Wazooli" wrote in message
...
Well, i did it by brute force, which works suprisingly well, just
inefficiently so. Anyway, after following another thread about extracting
cell color using a function getcolor(), I was wondering if there was a way
to
assign cell color with a function. please be gentle - I have absolutely
no
VBA skills.

"Ron de Bruin" wrote:

Hi Wazooli

Run this macro on a empty sheet


Sub ListColors()
Dim a As Long
For a = 1 To 56
Cells(a, 1).Interior.ColorIndex = a
Cells(a, 2).Value = a
Next a
End Sub


More info you can find here
http://www.mvps.org/dmcritchie/excel/colors.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Wazooli" wrote in message
...
After seeing many posts regarding extracting the color value of a cell,
I
am
wondering where one can get a listing of default colors with their
respective
codes.