Share via

Auto Highlight

Anonymous
2024-01-22T01:36:00+00:00

How to Auto Highlight Row Based on Cell Value in Excel

i made it based on conditional formatting; but, after the weekend when my computer rested for 2 days, the conditional formatting stopped working.

I did used "=ROW()=CELL("row")" formula

Microsoft 365 and Office | Excel | For business | 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 No comments
  1. Anonymous
    2024-01-22T04:16:23+00:00

    the file attachment is not active on my window,

    can you please talk me through file excel attaching process?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-01-22T04:07:30+00:00

    Could you also share us a test file to reproduce your issue? You may upload file in private message.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-01-22T04:03:47+00:00

    I have attached it here

    office plus 2021

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-01-22T03:53:14+00:00

    It still works at my side. Could you share us your office version?

    I have sent my test file in private message.

    Was this answer helpful?

    0 comments No comments