IF FUNCTION...SHADE CELL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast 3
Calculating Shaded Cells 2
Coloured Cells 8
If condition error 2
Cell shading problem 4
conditional formatting 1
Conditional Format & Default Format Help 1
Automatically Copy formatting (I.E. shading) 2

Back
Top