Extendinf conditional formatting to adjacent cells

[Jeff Granger]

Is there a way to extend the conditional formatting on a cell to other
cells?

I have a list of transactions with Date Purchased | Description | Cost |
Status.

When the value in Status is "Paid" I'd like the whole row to go green.

Can this be done?

Jeff

 

[Erik Veldkamp]

Select row, and in conditional formatting select " formula is" and enter
formula =$C$1="paid"

 

[Jeff Granger]

Magic

Thanks

Select row, and in conditional formatting select " formula is" and enter
formula =$C$1="paid"

 

[Earl Kiosterud]

Jeff,

If you'll be copying this row down, change the formula to

=$C1="paid"