nevermind - just saw another post that deals with this

"Wazooli" wrote:

I posted this in worksheet functions, but perhaps this forum is better. Is
there a way to use the colorindex property of a cell with conditional
formatting?

wazooli