Conditional formatting formula builder

Pick the rule; get the custom formula and where to paste it. The hard part of conditional formatting is not the condition — it is that the formula is written for the first cell of your range and filled down from there, and that one dollar sign is the difference between colouring a cell and colouring the whole row. This gets both right.

What you are formatting Apply to range

Start below your headings, or they get coloured too. Leaving the end row off (A2:F) covers rows you add later.

Column headings (optional)

Paste your heading row and the column picker uses your own names.

Colour

The rule Look at column …when it

Compared against

Fill in only what your rule asks for — anything else is ignored.

and (for “is between”)

Number of rows / days

Other column

Dates go in as yyyy-mm-dd. “Another cell” anchors the reference for you — an unanchored one slides down a row at a time and compares every row against something different.

Pick a rule and hit Build.

You'll get the formula, the range to paste it against, and a warning for each thing that usually goes wrong:

=$C2="Done"

Nothing is sent anywhere — the formula is composed in your browser.

Seeing it done

The channel walks this exact dialog — the custom-formula box, the range, the colour — in Conditional Formatting with a Custom Formula, and applies the duplicate rule above in How to Highlight Duplicates. The counting half of those rules is on the COUNTIF reference page.