Use Formulas With Conditional Formatting. Now lets see how to set up each of the four conditional formats using formulas How to Get Started with Your Conditional Formats. They only let me change the font formatting borders patterns etc.
In the Style box click Classic. Susan Harkins runs through 10 practical ways to put this tool to work. Enter the formula EXACT E6Yellow.
A question that often comes up among these conditional formatting addicts is Can I use IfThen formula to format a cell.
IF AND B45 B4. In the Style box click Classic. Under the Classic box click to select Format only top or bottom ranked values and change it to Use a formula to determine which cells to format. Click in the formula area and type ANDE2CAF2Google Ads Click Format and click the Fill tab.
