Can anyone tell me if i can use a formula to colour a cell in a Excel Worksheet if it is empty. That is is has no text, numbers or value.
Can anyone tell me if i can use a formula to colour a cell in a Excel Worksheet if it is empty. That is is has no text, numbers or value.
Last edited by davesexcel; 05-12-2012 at 10:11 AM. Reason: Title sucks
welcome to the forum.
in the -conditional formatting
Use a formula
=isblank(A1)
or
=ISBLANK(A1)=TRUE
don't use cell is.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks