Forum Discussion
Conditional Formatting each row individually
Select the entire worksheet, or just the rows in use.
The active cell should be cell A1.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =AND(A1<>"",A1=MIN(1:1))
Click Format...
Activate the Fill tab and select a highlight color.
You can also specify a font color and/or borders.
Click OK, then click OK again.
Repeat these steps, but with the formula =AND(A1<>"",A1=MAX(1:1)) and with a different color.
As you can see in F2 / G2, if there is more than one cell with the minimum (or maximum) value in a row, all of them will be highlighted.
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: