Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |