This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Answer accepted by question author
Upload file is available in private message.![](https://learn-attachment.microsoft.com/api/attachments/b454987c-fddb-4baf-a30a-c9c10946726c?platform=QnA
the file attachment is not active on my window,
can you please talk me through file excel attaching process?
Could you also share us a test file to reproduce your issue? You may upload file in private message.
I have attached it here
office plus 2021
It still works at my side. Could you share us your office version?
I have sent my test file in private message.