Excel - Input data in a range of cells

July 2017




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


Published by aakai1056. Latest update on September 8, 2012 at 03:53 AM by deri58.
This document, titled "Excel - Input data in a range of cells," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).