Microsoft Excel Tips and TricksMake better charts in Excel. Automatically format specific bars based on a condition. No one likes to manually highlight or color code data in charts. As soon as something changes you’ll have to do it all over again. I’ll show you a quick and easy way to conditionally format your bar or columns charts in Microsoft Excel. This is a great Excel chart trick you can apply right away.
Credit Leila Gharani