ExcelBanter - IF FUNCTION...SHADE CELL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF FUNCTION...SHADE CELL (https://www.excelbanter.com/excel-discussion-misc-queries/31914-if-function-shade-cell.html)

Jambruins

IF FUNCTION...SHADE CELL

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

Ron de Bruin

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

All times are GMT +1. The time now is 04:48 AM.