Explore and use preset rules for conditional formatting Thanks to Microsoft’s preset rules, you don’t necessarily need to create a custom rule from scratch.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

Turn raw data into actionable insights with Excel 365’s conditional formatting. Learn to create dynamic visuals with ease in this guide.

I think I understand how to use conditional formatting in Excel. However, I cannot belive that I can only format the specific cell that match the format only.