Why Flag Large Transactions
When you review a month of bank activity, the entries that deserve a second look are usually the biggest ones. Instead of scanning the amount column by eye, you can have Excel colour any amount above a limit you choose. Conditional formatting does this, and the colour updates if you later change an amount.
Microsoft's documentation describes built-in criteria such as Greater Than, which apply to text, number and date values, and a formula-based option for rules the built-ins do not cover. Both are useful for transaction lists.
The Sample Data
The example uses made-up transactions with amounts in column C, rows 2 to 7, and a threshold of 500:
C2 Brightside Hardware 84.20
C3 Harbour Office Rent 950.00
C4 Lemon Tree Cafe 12.75
C5 Orbit Electronics 499.99
C6 Summit Insurance 500.00
C7 Cedar Garage Repairs 730.40Using a limit of 500, the rule should colour 950.00 and 730.40. The 500.00 row is exactly equal to the limit, and 499.99 is below it, so a strict "greater than" test leaves both uncoloured. Decide up front whether an amount equal to your limit counts, because the rule type you pick determines that.
Method 1: The Built-In Highlight Cells Rules
Microsoft's article for Excel on Windows describes the built-in route this way: select the cells, then on the Home tab, in the Style group, click the arrow next to Conditional Formatting and click Highlight Cells Rules. You then pick the comparison you want, enter the value and choose a format. Greater Than is named in the article as a built-in criterion, although the page does not give a separate worked example for it.
For this data, select C2:C7, choose the greater-than comparison, enter 500 and pick a fill colour. The amounts 950.00 and 730.40 take the format.
Method 2: A Formula-Based Rule
For more control, Microsoft describes a rule that is driven by a formula. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, then Manage Rules and New Rule. Under Select a Rule Type, click Use a formula to determine which cells to format. In the Format values where this formula is true box, the formula must start with an equal sign and return a logical value of TRUE or FALSE. Then click Format, choose your format and click OK.
With C2:C7 selected and C2 as the first cell, the rule is:
=C2>500Microsoft notes that if you want Excel to adjust the references for each cell in the selected range, you should use relative cell references, and that selecting cells on the worksheet while writing a formula inserts absolute references. If you click C2 to build the formula, check that Excel has not locked it, or every row will be compared against the same cell. Microsoft's own examples of this style use comparisons such as =A2>TODAY(), which compares each cell in turn.
Excel returns TRUE or FALSE for each row, and only TRUE rows take the format. If an amount equal to the limit should count as large, lower the threshold in the formula (for example =C2>499.99 for amounts with two decimal places).
Check the Amounts Are Numbers
Colour rules are only as reliable as the data. If amounts arrived as text, comparisons may not behave as you expect, so confirm the column holds real numbers before you rely on the colours. Converting a statement PDF to a spreadsheet first is one way to start with clean rows. PDFtoRow converts bank statement PDFs to Excel or CSV and shows a free preview of the first 10 rows.
Convert Bank Statement PDFs Cleanly with PDFtoRow
Tired of fixing broken columns, corrupted dates, and numbers stored as text? PDFtoRow extracts transaction tables directly from digital PDF vector layers, preserving check numbers and outputting true numeric amounts. Statements up to 5 pages are free once per email every 24 hours. Check the 10-row preview before you download.
Frequently Asked Questions
Microsoft states the formula must start with an equal sign and return a logical value of TRUE (1) or FALSE (0). Cells where it is TRUE receive the format.
Check the cell references in the formula. Microsoft says that selecting cells while writing a formula inserts absolute references, and that you should use relative references if you want Excel to adjust the reference for each cell in the range.
A strict greater-than test such as =C2>500 does not colour an amount of exactly 500.00. Lower the threshold slightly (for example =C2>499.99) if equal amounts should be flagged too.
Primary Evidence & Official References
- Use conditional formatting to highlight information in Excel — support.microsoft.com (Verified 2026-10-29). Official source documentation →
- Use a formula to apply conditional formatting in Excel for Mac — support.microsoft.com (Verified 2026-10-29). Official source documentation →