How can i apply a conditional formatting rule to all rows except first row?

excel excel-formula conditional-formatting
RAM picture RAM · Jan 8, 2017 · Viewed 14.4k times · Source

My problem is about programming in excel (create a formula for conditional formatting rule).

If i use the following formula in my format condition formula:

=INDIRECT("A"&ROW())>1

And apply on all rows include first row with following range in Apply to field:

$A:$F

Result: It works well.

But i want apply it to all rows except first row. So i changed it to:

=AND(INDIRECT("A"&ROW())>1;ROW()>1)

Result: Now it did not work on any row.

What is my mistake in the above formula?

Answer

Alain picture Alain · May 17, 2019

Just add an extra formula rule to the row(s) you would like to exclude. Set the formula to TRUE and tick the Stop If True option. This rule should be on top of the rule list.

Exclude from conditional formatting

Related questions

Conditionally formatting if multiple cells are blank (no numerics throughout spreadsheet )

I have created a spreadsheet in Excel and am attempting to use Conditional Formatting to highlight a cell or row if any or all of the cells in the last four columns are blank. My columns consist of name of …

Read More
Conditionally formatting cells if their value equals any value of another column

I have data in the A and B columns. B column's data is mostly duplicates of A's data, but not always. For example: A Budapest Prague Paris Bukarest Moscow Rome New York B Budapest Prague Los Angeles Bukarest I need …

Read More
Conditional formatting using AND() function

I'm trying conditional formatting on a sheet. I need to fill the cells with a certain color according to the following conditional statement: =AND((INDIRECT(ADDRESS(4;COLUMN()))>=INDIRECT(ADDRESS(ROW();4)));(INDIRECT(ADDRESS(4;COLUMN()))<=INDIRECT(ADDRESS(ROW();5)))) When I …

Read More