In Excel 2007, I can use a formula to highlight an entire row based on the
value in one cell. What I cannot figure out is how to highlight two rows.
It will highlight one every time!! What am I doing wrong?

I highlight both rows
I click conditional formatting
Formula= $D4="a"
click my formatting
ok

Only one row is highlighted!!

One way:

Change

$D4

to

$D$4

In article ,
Tamara wrote:

In Excel 2007, I can use a formula to highlight an entire row based on the
value in one cell. What I cannot figure out is how to highlight two rows.
It will highlight one every time!! What am I doing wrong?

I highlight both rows
I click conditional formatting
Formula= $D4="a"
click my formatting
ok

Only one row is highlighted!!

I suspect that if you will discover that if you put an "a" in D5 it
would change the highlighting, so use $D$4= "a"

Tamara wrote:

In Excel 2007, I can use a formula to highlight an entire row based on the
value in one cell. What I cannot figure out is how to highlight two rows.
It will highlight one every time!! What am I doing wrong?

I highlight both rows
I click conditional formatting
Formula= $D4="a"
click my formatting
ok

Only one row is highlighted!!