top of page

Applying conditional formatting with formulas


You can use formulas to apply conditional formatting in Excel.

Begin by selecting the range you want the conditional formatting applied to. On the Home tab, select Conditional Formatting . . . New Rule.

In the 'Select a Rule Type' list, choose 'Use a formula to determine which cells to format'. In the box labeled, 'Format values where this formula is true:" enter a formula such as, "=$D2>=$H$3" This will apply the formatting to all values in column D greater than a target value entered in cell H3. Then click on the Format button and make the desired settings.

Excel applies the formatting to all rows in the selected range for which the value in column D meets the stated criteria.

Note when applying a rule be sure not to select the column headings and point the formula to the first cell holding actual data.


Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page