It's not simple but see
http://www.xldynamic.com/source/xld.CFConditions.html
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"mistus" wrote in message
oups.com...
hi,
i have a colorscale (conditional formating ) in range A1:A20 and I'm
trying to get color number for each cell. In normal case
a = Range("a1").Interior.Color
b= Range("a2").Interior.Color etc.
works fine.
But when colors of cells are from conditional formating i dont know
how to get color number.
how to do that?
Mistus