I currently have a formula im using in conditional formatting that formats a cell differently if G contains Relocate and E is blank. How could I change the formula to be if G contains any data and E is blank?
Current formula:
=AND($E6="",$G6="Relocate")
maybe
=and(isblank(E6),G6<>"")
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
Thanks, I just had to change the E and the G around.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks