Try a UDF

Function CI(rng as range)
if rng.count = 1 then
CI = rng.interior.colorindex
endif
End Function

and use like

=IF(CI(A1)=6,...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Martin Williams" <Martin wrote in
message ...
I want to make the contents of a cell dependant on whether another cell is
highlighted in yellow or not. I can find no way of doing this. I'm using
Excel 2003, but would also like to use on Excel 2000.