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