Applying Conditional Formatting to more than one cell....

[erve]

I am wondering if it is possible to format more than one cell with conditional formatting? What I mean is if cell A1 equals "y", then the entire row is formatted, including A1, regardless of what is written in cells A2:A18, for example.

Any help would be greatly appreciated.

 

[Bob Greenblatt]

I am wondering if it is possible to format more than one cell with conditional
formatting? What I mean is if cell A1 equals "y", then the entire row is
formatted, including A1, regardless of what is written in cells A2:A18, for
example.

Any help would be greatly appreciated.

Sure it is. That¹s one of the powers of conditional formatting. Simply
highlight all the cells you want formatted based on this condition. Select
Format-conditional formatting. Select Formula and type in =$a$1=²Y² Press
enter and then select the formatting.

 

[erve]

Thanks very much Bob! Of course it now seems obvious......

 

[erve]

Having it said it seems obvious, I now have a second problem. I managed to apply the formatting to the required rows, but it seems to disappear...

Basically, I have a list (using the List option) of names and addresses in columns. I want to highlight the entire row if "Y" is added to the first column. I therefore sorted the list by "Y" (ie selecting sort ascending from the 1st column), which brought all the entries with "Y" in the first column to the top.

I then did exactly what you told me in order to make all the rows yellow (if "Y" is in comlumn 1), which worked. I filled the formatting down through all the relevant entries. All fine so far.

I then re-sorted the entries alphabetically (ie sort ascending in column 3) and the formatting disappeared. All the "Y"'s were still in the correct rows in column 1, but no yellow anywhere.

I re-sort using column 1 (bringing all the "y"'s to the top) and the formatting reappears. Back to alphabetical and it disappears again. I tried restarting Excel, no change. Is this a bug, or am I not doing something right??

Many thanks in advcance!!

George

 

[Bob Greenblatt]

Having it said it seems obvious, I now have a second problem. I managed to
apply the formatting to the required rows, but it seems to disappear...

Basically, I have a list (using the List option) of names and addresses in
columns. I want to highlight the entire row if "Y" is added to the first
column. I therefore sorted the list by "Y" (ie selecting sort ascending from
the 1st column), which brought all the entries with "Y" in the first column to
the top.

I then did exactly what you told me in order to make all the rows yellow (if
"Y" is in comlumn 1), which worked. I filled the formatting down through all
the relevant entries. All fine so far.

I then re-sorted the entries alphabetically (ie sort ascending in column 3)
and the formatting disappeared. All the "Y"'s were still in the correct rows
in column 1, but no yellow anywhere.

I re-sort using column 1 (bringing all the "y"'s to the top) and the
formatting reappears. Back to alphabetical and it disappears again. I tried
restarting Excel, no change. Is this a bug, or am I not doing something
right??

Many thanks in advcance!!

George

It's hard to say. My guess sis that it is probably not a bug. In your
conditional formula did you enter $a$1? Perhaps that is what I told you to
do. In which case, all cells are looking to A1. What you should have entered
is $a1. Reselect all the cells, make sure A1 is the active cell and then
change the formula to $a1. The formula now means look in column A of this
row. Sorry for the confusion

 

[erve]

That got it. Thanks Bob.