Excel - Input data in a range of cells

Ask a question



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.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team