How to use the Spreadsheet Conditional Formatting Generator.
Conditional-formatting formulas depend on the selected range and relative references. State which row the rule starts from.
Make the workflow fit your task.
Specify the formatting range and write the rule relative to its first cell. Lock only the row or column that should remain fixed, then test a matching row, a nonmatching row and a blank. Review existing rules for precedence conflicts.
- What you provide
- Columns and visual rule.
- What you get
- Conditional-formatting formula and setup instructions.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Highlight rows A2:D100 when column C contains Overdue.
Completed example
Use =$C2="Overdue" for the selected range, then verify the application's conditional-formatting settings.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Why use $C2 instead of C2 or $C$2 for a whole-row rule?
The locked column keeps each cell checking column C, while the relative row lets the check move down the selected range.
Why are rows highlighted one row too early?
The formula's starting row may not match the applied range. Align the rule with the range's top-left cell.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑