MS EXCEL - Conditional Formatting?

Question

I want to do the following -

When I Change the value in a perticular cell, whole row (Or selected range) should be coloured as I set. It can be done by CONDITIONAL FORMATTING, but I donn't know how it can done.

As u know I can do this easily with only current selected cell but I want to do this whole the ROW. Is it possible. If yes, please describe how.

Thanks,

Harry!

Answer 1

If, you have set the conditional format to one cell, then
- click on the format painter icon on the standard toolbar - (looks like a paint brush)
- click on the row number - to paste the same conditional format across the row

Works for me.

Answer 2

If I got you well, You may need some VBA job, I did this here for someone in Yahoo! Answers.
What you need is to set Conditional formatting for all other cells into
Formula is
and

=$A$1=14

and paste for all other cells

XLMan

Answer 3

contained in the column the position you want the colour, click the conditional formatting arrow (this is on the abode tab of th eribbon). decide on "highlighe cells guidelines" and decide "equivalent to". Then contained in the container style Monday, and then contained in the container to the right, click the arrow and decide custom format and decide regardless of colour you want. set up you a rule for each day's colour that you want. then you actually can reproduction the formatting to any cells on the spreadsheet once you be sure your guidelines.