Excel - Input data in a range of cells

December 2016




Issue


If i want to highlight a row of cells in red to show a
lead is dead say A1 to E1, buy inputting "lose" in E1.

I now have the formula =$A$1="lose" which is great thank you.
  • But I now want the rest of the spread sheet to do the same up to line number 1000, if I try to copy and paste special it doesn't carry over the conditional formatting over.
  • Do I need to input every single line in manually or is there a formula to do this please. Thank you for your help so far.

So I need A2 to E and then from A3 to E

Etc to 1000 each line independent of the last, I hope that makes sense.

Solution


Select columns A:E and in conditional format type:
=$A1="lose" 

and close color red

You can also select A1:E1 drag it down till row 1000 and when you release a small square appears, click the square and you will get 4 options. Choose the third from the top, something like 'Apply format only'.

Note


Thanks to rizvisa1 for this tip on the forum.

Related :

This document entitled « Excel - Input data in a range of cells » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.