IF FUNCTION...SHADE CELL

J

Jambruins

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
 
Top