G
Guest
Hi,
I have a list of data. It is 4 columns by 100 rows. Cells A2102
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 A22
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.
I have a list of data. It is 4 columns by 100 rows. Cells A2102
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 A22
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.