Conditional Formatting needs to ignore formula that outputs a blank value

I am trying to have a conditional format where if there is a value in cell A7 then C7 will be become highlighted yellow. The problem is that we made a change and the A7 value is now determined by a formula, even if the formula returns a blank the old conditional format we used thinks the formula is a value. Does anyone have any idea how to adjust or change the formula we were using? The old formula we are using is:

=AND(NOT(ISBLANK(A7)),ISBLANK(C7))

mpcollins,

Attached is a sample workbook of what I think you described. Column C has the following conditional format formula applied to it:
=AND(A1<>"",C1="")

Hope that helps,
~tigeravatar

Thanks for the quick response, that didn't seem to work. I attached the spreadsheet I'm working with. The VLookup I have in there won't link correctly to the propper table but I'm hoping this will give you a better idea what I'm dealing with. I have 2 different ways of formatting the VLookup in cells A8 and A9. Whatever one you think would be easier to work with is fine with me.

thanks!

mpcollins,

The problem is that your VLOOKUP formulas don't return blank cells, they return a space. Instead of " " just use ""

Example: =IF(ISBLANK(VLOOKUP(6,'T:\Path\[Filename.xlsx]Sheetname'!$A$5:$F$224,6,TRUE)),"", ...

~tigeravatar

Thanks for all your help, works like a charm now!

Im using formula: IF(LEN($AL5)>1,$R5,"")
When I use conditional formatting to highlight given cells using(cell value >0), it highlights the blank cells.?