Use CF

See this site
http://www.contextures.com/xlCondFormat03.html




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


"Jambruins" wrote in message ...
Here is my formula. Instead of having an X show up if the formula is true I
would like the cell to shade itself red.
=IF(VLOOKUP(S44,Pinny!I:J,2,0)0,"X","")

Thanks