Conditional formatting

[ab304]

Morning all,

I have a range in which each cell has an if statement which if TRUE returns a value, but if FALSE returns "". I'm trying to conditionally format this row so that if the formula returns "" the cell becomes completely unformatted (i.e. no borders etc.).

I'm sure the answer is quite simple but I'm really struggling. I've tried formatting if the cell is blank, but I guess since it has a formula in it excel doesn't see it as blank. I've tried to format if the cell contains "", but that doesn't seem to work either.

Any ideas?

Edit to say I'm using Excel 2007

 

[pedro-egoli]

What conditions do you have for conditional formatting?

Perhaps this link which solved a similar problem for me might assist
http://www.mrexcel.com/forum/showthread.php?t=553408

Pedro

 

[ab304]

I actually got round it another way by having a hidden column which looked to see if the cell with the if statement formula was returning "". If the formula result is "" then return FALSE.