Excel: Highlight a number cell based on the text contents of another cell / cells

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.

For more resources for Microsoft Excel