Forum Discussion
Solved
Can I format the rows of cells in a data table when the value in one column changes?
I downloaded banking transactions, which were sorted by the 'Send on' date. I want to format rows with the same 'Payee' with the same color efficiently using Excel Conditional Formatting or Format as...
- Reply is to Microsoft Excel department directly. Why are such common needed features like simply shading rows based on changing value in a single column not automatically provided as a select column & apply? Why do people have to go through the long winded route explained via this link:
https://www.extendoffice.com/documents/excel/2661-excel-alternate-row-color-based-on-group.html
Reply is to Microsoft Excel department directly. Why are such common needed features like simply shading rows based on changing value in a single column not automatically provided as a select column & apply? Why do people have to go through the long winded route explained via this link:
https://www.extendoffice.com/documents/excel/2661-excel-alternate-row-color-based-on-group.html
https://www.extendoffice.com/documents/excel/2661-excel-alternate-row-color-based-on-group.html
- Thanx syedalix! Somebody smarter than I sure knows Excel better than Microsoft, it would seem. This is what I needed. I will pass the article on as further replies come in. Best Answer!
