Forum Discussion
Conditional Formatting each row individually
It didn't work for me. Of around 800 cells only 5-10 of the minimum condition were filled (none for maximum, I suspect this could be because of my data but thought I'd share it) and not even the right ones. I copy-pasted so what could be the issue? Also I restarted Excel in case it wasn't loaded (has happened before with a lot of conditional formatting).
I have the 16.78 version of Excel if it helps.
Thanks in advance!
Edit: Forgot to mention, I was careful about the starting cell (F2 to K857, so I replaced A1 with F2)
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I tried in a different empty workbook and it worked, I don't know what's going on...
- PS: I didn't think about sharing a worksheet.. I added it now to the drive.
HansVogelaar This is from F796 to K822, you can also see the problem with the formatting. I also included the Conditional formatting window.
Image upload not working correctly here's a google drive link:
https://drive.google.com/drive/folders/11KgmmahkiBM4iGKJ2lwyFpUtXq19yb5l?usp=share_link
As you can see, the formulas in the rules refer to the wrong ranges:
They should look like this:
- All of the suggestions severely fail the "I'm hoping I don't have to apply over and over row by row." constraint. Is there any method that doesn't?
