Jan 13 2022 09:16 AM
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 Table. For this example, I used the Sort & Filter function with the Editing tool. I then filtered each individual Payee and chose a highlight color. I could have also just sorted the rows by Payee and then highlighted again by selecting the rows with same Payee and highlighted that section.
Is there a function in Excel that will format these rows using a formula or other tool?
Jan 13 2022 11:11 AM
Jan 13 2022 11:23 AM
Jan 13 2022 01:19 PM
Jan 29 2022 11:49 AM
SolutionJan 30 2022 02:53 PM
Jan 29 2022 11:49 AM
Solution