Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Violet Nelson   on Jan 30 In MS Office Category.

  
Question Answered By: Muhammad Evans   on Jan 30

You can't change  the colour of a row  in one go. You'll need to do it for
each cell.

That said, you can select as many cells as you wish, and do them all in one
go.

- select the cells
- Alt-O, D (of Format / Conditional Formatting
- first drop-down to "Formula Is"
- type the formula =$a45="PASS"
- click Format...
- Patterns
- select a colour you like and click OK
- OK again

I used row 45, you can use whatever row you prefer. Then select the area
again and

- Copy
- select the whole area that is to do this (i.e. all the rows and all the
columns)
- Paste Special / Formats

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on how to change color of row based on dropdown list Or get search suggestion and latest updates.


Tagged: