| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| Get current cell with VBA function | Excel Worksheet Functions | |||
| Function to operate on ink linked to cell | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Linear Mode
