Share via

Excel Conditional Formatting Bug when formatting entire rows?

Anonymous
2019-08-23T20:08:29+00:00

Something weird is happening in Excel with conditional formatting.

I'd like to format a range of cells row-by-row based on the value in one column.  In this example, I want all rows with a value of '0' in column C to be highlighted in green.

I use this conditional formula on range A2:C8: 

=$C2=0

After clicking OK, the formula changes to something like this:

=$C1048572=0

And the cells are formatted accordingly:

I then have to edit the conditional formula to fix it and it works the second time.

Am I doing something wrong or is this a bug?

Thanks,

Grant

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2019-08-23T21:38:44+00:00

    Make sure that the active cell within the selection is in row 2 when you specify the conditional formatting rule.

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-24T14:27:28+00:00

    Thanks HansV.  That's what I was doing wrong.

    Cheers,

    Grant

    0 comments