Conditional Formatting Generator

Create Excel conditional formatting rules with live preview. Generate formulas for highlighting cells based on various conditions.

Rule Builder

Live Preview

SalesRegionStatusAmount
Q1NorthComplete15000
Q2SouthPending8500
Q3EastComplete12000
Q4WestFailed5000
Q1NorthComplete9000

Excel Formula

=AND($D$2:$D$1000>10000)

How to use:

  1. Select the column you want to apply the formatting to
  2. Choose a rule type and set the condition values
  3. Customize the formatting (colors, bold, italic)
  4. Preview the results in the live preview table
  5. Copy the generated Excel formula
  6. In Excel, create a new conditional formatting rule using a formula
  7. Paste the formula and apply your chosen formatting