I think the easiest solution would be to mimic that formula in a cell on the
same row.

Working with Conditional Formatting ain't for the faint of heart:
http://cpearson.com/excel/CFColors.htm

(From Chip Pearson's site)

jc wrote:

No takers :(

--

Dave Peterson