Conditional Formatting

[MrManBoy]

Hi All,

Problem/Headache: I am trying to apply some sort of conditional formatting based on a cell value however, I only want the formatting to affect the corresponding cell to left or right not the whole column. Not sure if that even made sense, sorry if it didn't.
.
Example: In B1 I have a dropdown list of X amount of words. For the sake of this example lets say they are "Apples", "Oranges" and "Pears". If I was to select any of these words in A1 except "Oranges", then I would like to put a strikethrough whatever word that is in A1 or A3 for that matter. Then repeat this as I go down column B etc.

What I have done: Other than give myself a headache, I can get the formatting to work but can only to get it to work for one cell or the whole column.

Hope this makes sense otherwise, please let me know and I'll try to elaborate further.

Thanks in advance!

 

[63falcondude]

Hi All,

Example: In B1 I have a dropdown list of X amount of words. For the sake of this example lets say they are "Apples", "Oranges" and "Pears". If I was to select any of these words in A1 except "Oranges", then I would like to put a strikethrough whatever word that is in A1 or A3 for that matter. Then repeat this as I go down column B etc.

Did you mean any of these words in B1? You said that you have your drop down in column B. If this is the case, try selecting A1:A3 (or however far your data goes), use the rule =B1<>"Oranges", format strikethrough, ok. Your data will come out like this:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]Apples[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]Oranges[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Z[/TD]
[TD="align: center"]Pears[/TD]
[/TR]
</tbody>[/TABLE]

In this example, pretend that the underlines are strikethroughs.

Is this what you are looking for?

 

[MrManBoy]

Did you mean any of these words in B1? You said that you have your drop down in column B. If this is the case, try selecting A1:A3 (or however far your data goes), use the rule =B1<>"Oranges", format strikethrough, ok. Your data will come out like this:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]X[/TD]
[TD="align: center"]Apples[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]Oranges[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Z[/TD]
[TD="align: center"]Pears[/TD]
[/TR]
</tbody>[/TABLE]

In this example, pretend that the underlines are strikethroughs.

Is this what you are looking for?

Yes sorry I meant B1 not A1 - Thanks for the reply I will give this a go in a moment or two and let you know how I managed to stuff this up

 

[MrManBoy]

THANK YOU SO MUCH 63falcondude THIS IS EXACTLY WHAT I WAS AFTER!!

SUCH A SIMPLE RESOLUTION YET I WAS PUTTING IN FORMULAE THAT WOULD PROBABLY SOLVE CANCER...OK PERHAPS NOT QUITE

ANYWAYS...


MANY THANKS!

 

[63falcondude]

If only a formula could do that! Glad to help.