I'm not an excel expert, just a mere daily user, but i decided to take the next step and learn how to do more with my data. I've searched a lot before deciding to register and post here, but i didn't really find the information suitable for me. Here's what i want to accomplish: I want to be able to highlight a number cell if it remains empty after a certain text is entered in the ones from left and/or right. So: In the E and G column i have some text info, in F there should be a number, but only if a certain text is entered in E and/or G. Sometimes, i forget to enter that number and i want that cell to highlight.
This question generated 21 answers. To proceed to the answers, click here.
This thread is current as of March 26, 2014.