Hi
I have a workbook that creates a monthly task calendar in one of the
spreadsheets. in that sheet, there is a list of tasks in Column A, while
Column B contains the formula :
=IF(ISERROR(VLOOKUP(A3,'calendar~data'!$B$5:$O$36, 14,0)),"",VLOOKUP(A3,'calendar~data'!$B$5:$O$36,14 ,0))&""

where A3 is a date. The cells in Column B therefore appear either blank or
return a value.

I want to apply conditional formatting only to those cells in Column B that
return a value. The colour formatting will alert a staff member that they
have a task to complete on a certain day if it is shaded with 'their' colour.
I've fuddled around with variations including IF, ISBLANK and NOT(ISBLANK)
but to no avail. can anyone assist?

Thanks.