Select row. conditional formatting, Formula is:
=$A2="Desired Status"
Choose desired color.


Modify formula to match your column and desired status. Note the use of the
aboslute reference ($) to force all cells within the row to look at a single
column.
Copy formatting down as desired.
--
Best Regards,

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


"CatherineLS" wrote:

I am trying to format rows that change color when the status of a column
within those rows changes. Any help is appreciated.
--
CatherineLS