Copying Conditional Formatting down!

It looks like you’re trying to conditionally format a column so that most cells are red, but the second cell specifically should be green. In Excel, conditional formatting rules are applied in order, and the first rule that matches a cell takes precedence unless you use the “Stop If True” option.

Select the entire progress column, then go to Conditional Formatting > New Rule > Use a formula to determine which cells to format. For the second cell (assuming the column is B and the second row is 2), use:

=ROW()=2

Set the fill color to green. Make sure this rule is above your rule that makes everything else red in the Conditional Formatting rules manager. For the general red rule, you can have something like:

=TRUE

and set the fill color to red. This way, Excel will format row 2 as green first, then apply red to all other cells.

If your red formatting is based on a condition rather than just a blanket red, make sure the green rule still comes first and references the row correctly.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin