How to use conditional formatting for rows, based on info in cells

[Ash09]

I am trying to make rows a different color based on what I enter in a column.
How do I do this? I know how to get the one cell to change based on what I
type in it, using the conditional formatting…but I want the whole row that
color.

 

[Luke M]

Say you want the row formatted if column A is equal to "X"
Select all of row 2 (or just a cell in row 2, doesn't matter). Conditional
format, formula is
=$A2="X"
Set format.

You can then copy across/down as much as desired

 

[Sri]

Say you want the row formatted if column A is equal to "X"
Select all of row 2 (or just a cell in row 2, doesn't matter). Conditional
format, formula is
=$A2="X"
Set format.

You can then copy across/down as much as desired
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Luke has suggested it well. You got to use '$', to apply the color for
the entire row, just A2 applies for the column.
Check the articles below to get more insight about conditional
formatting
http://funwithexcel.blogspot.com/2009/04/macro-for-conditional-formatting-in.html
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html