Hi i am currently using the following formula to stop my conditional formatting from happening if the the cell next to it is blank.
But the Cell is just staying red please see attached workbook sample.
Please Login or Register to view this content.
The cell i am talking about is Q10 on the student details and data tab.
Last edited by Jamidd1; 02-20-2016 at 03:55 PM.
Try
=P10=""
As you set P10 to null("") in your formula (not same as blank " ")
Thank you very much! That makes sense, I can see where i was going wrong!
I think you will also have to change the order so the formula JohnTopley suggests is fired before the others.
BSB
Don't see an attachment.Originally Posted by Jamidd1
The ISBLANK function is not correctly named based on its characteristics.
It should have been named ISEMPTY.
If a cell contains a formula blank "" ISBLANK returns FALSE which you would not expect it to!
Better to use logic statements like:
=A1="" (A1 is blank/empty)
=A1<>"" (A1 is not blank/empty)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks