Hi,

I have a list of data. It is 4 columns by 100 rows. Cells A2:D102

If the last column in the row is = "D" I want to highlight that row.
So for example

If Cell D2 = "D" then highlight Cells A2:D2

Is there any way to do this using conditional formating, I was trying but it
would not highlight the other cells - I could highlight cell D2, but not
cells A2:C2, based on the value of cell D2.

In the conditional formatting box (Formatting-"Conditional Formatting"),
Choose "Formula Is" from the dropdown box, and enter this formula (verbatim)
in each cell in row 2, choose your formatting, then drag down:

=$D$2="D"


--
Regards,
Dave


"Jeff" wrote:

Hi,

I have a list of data. It is 4 columns by 100 rows. Cells A2:D102

If the last column in the row is = "D" I want to highlight that row.
So for example

If Cell D2 = "D" then highlight Cells A2:D2

Is there any way to do this using conditional formating, I was trying but it
would not highlight the other cells - I could highlight cell D2, but not
cells A2:C2, based on the value of cell D2.

Hi,

Starting with A2, select the entire data (i.e., A2...D102) , and under
Conditional Formatting,
'Formula Is' =$D2 = "D" and format to shade the row(s).

Regards,
B. R. Ramachandran

"Jeff" wrote:

Hi,

I have a list of data. It is 4 columns by 100 rows. Cells A2:D102

If the last column in the row is = "D" I want to highlight that row.
So for example

If Cell D2 = "D" then highlight Cells A2:D2

Is there any way to do this using conditional formating, I was trying but it
would not highlight the other cells - I could highlight cell D2, but not
cells A2:C2, based on the value of cell D2.