![]() |
Conditional Formatting
I am trying to format rows that change color when the status of a column
within those rows changes. Any help is appreciated. -- CatherineLS |
Conditional Formatting
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 |
All times are GMT +1. The time now is 07:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com