This question already has an answer here:

I have a few things that I would like to do on Excel:

  1. How do you highlight a row [A-U] if only the first cell A has had text entered in it? When you enter text in cell A cells B-U have a yellow background?
  2. How do you make the highlighting disappear as you fill the cells? When you enter text in any of the B-V cells, they return to the white background?
  3. How do you make certain cells not have a yellow background with a key word? When you enter "Cats" in cell G, cell H returns to the white background as well as cell G.
  4. How do you apply this to the entire Excel sheet?

marked as duplicate by Raystafarian, Ƭᴇcʜιᴇ007, DavidPostill, mdpc, Matthew Williams Jan 8 '15 at 9:11

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


Here are the rules. If you'd like them for the entire sheet then simply extend the range (Applies to)...


Please note that the order is important

enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.