Excel Conditional Formatting Until the First Entry in a Row
Question details
Highlight empty cells in columns E through M until the first entry in each row, provided column C contains a value.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet uses formatting to remind users to make a selection in one of the tracked cells after entering a value in column C.
- Observed behavior
- The desired formatting highlights blank cells before the first entry and leaves the entry and all subsequent cells unformatted.
Identify the first row to format and select the range from column E through column M, starting with that row. The example below starts at row 3; adjust the row number in the formula to match your selection.
Create a Conditional Formatting Rule That Stops at the First Entry
Use a formula-based rule to highlight blanks before the first completed cell in each row.
Select E3:M3 for one row, or select a range such as E3:M100 for multiple rows. Make sure E3 is the active cell.
On the Home tab, select Conditional Formatting > New Rule, then choose Use a formula to determine which cells to format.
In the formula box, enter =AND($C3<>"",E3="",COUNTIF($E3:E3,"<>")=0). If your selection starts on another row, replace both row 3 references and E3 references with that starting row.
Select Format, choose a fill color on the Fill tab, and select OK. Select OK again to apply the rule.
Enter a value in C3, then enter a value in G3. Cells E3 and F3 should be highlighted, while G3 through M3 should remain unformatted by this rule.

Highlight Cells Before the First Entry in WPS Spreadsheets
Use a formula-based conditional formatting rule in WPS Spreadsheets to highlight blank cells before the first entry in each row.
- 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and select E3:M3, or a larger range such as E3:M100.
- 2. Add a rule: On the Home tab, open Conditional Formatting and choose New Rule. Select the option to use a formula to determine which cells to format.
- 3. Enter the formula: Enter =AND($C3<>"",E3="",COUNTIF($E3:E3,"<>")=0) in the formula field, changing row 3 if your selection starts on a different row.
- 4. Set and test the format: Choose a fill color in Format and confirm the rule. Enter a value in column C and then in one cell from E to M to check that highlighting stops at the entry.

Frequently Asked Questions
Why are no cells highlighted when column C is blank?
The rule includes $C3<>"", so it only highlights cells when column C in the same row contains a value.
How do I apply the rule to several rows?
Select a range such as E3:M100 before creating the rule, with E3 as the active cell. The relative row references let the rule evaluate each row separately.
What happens if the first entry is in column E?
No cells in E through M are highlighted by this rule, because there are no blank tracked cells before the entry.
How can I change the range where the rule applies?
In Excel, open Home > Conditional Formatting > Manage Rules and edit the Applies to range. If the starting row changes, update the formula references to match it.




