hi,
Using CF highlight cell A1 if E1 = "" ( but E1 has formula and if formula result is nothing or blank then highlight the cell A1 )
thank you
hi,
Using CF highlight cell A1 if E1 = "" ( but E1 has formula and if formula result is nothing or blank then highlight the cell A1 )
thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Try
CF rule
=OR(LEN(E1)=0,E1=0)
PERFECT FORMULA
THANK YOU JhonTopley
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks