Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have this formula entered into a range of cells -
=IF(ISNA(VLOOKUP(B5,April,D$2,FALSE))=TRUE,"",VLOO KUP(B5,April,D$2,FALSE)) This will produce either a number (negative or positive or zero) or a blank cell. (Is "" a blank cell?) I have conditionally formatted the range to change the font colour to white if the value is equal to zero (effectively hiding zero's) and wish to add an additional condition changing the cell colour to grey if it is a blank cell (or equal to ""). How do I / Can I do this? The formula above works, but can it be improved? My grateful thanks to all who respond. Dave Moore |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |