Conditional formatting - Creating a formula | Excel forum

. Here are the steps:
1. Greater Than (Green):
o Select the cell range where you want to apply the formatting (e.g., D5:D10).
o Go to the Home tab and click on Conditional Formatting.
o Choose Greater Than and set the comparison cell to $C$4 (or any other cell you want to compare with).
o Pick a format (e.g., light green fill) and click OK.
2. Less Than (Red):
o Follow the same steps as above but choose Less Than instead.
o Set the comparison cell to $C$4.
o Pick a format (e.g., light red fill) and click OK.
3. 1% Less or Greater (Amber):
o Again, follow the same steps, but this time choose Use a formula to determine which cells to format.
o Enter the formula: =AND(D5>=0.99*$C$4, D5<=1.01*$C$4).
o Select your desired format (e.g., amber fill) and click OK2
This will highlight cells based on your specified conditions. Feel free to adjust the formatting and cell references as needed!


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector