Jan 29, 2020
How to I copy conditional formatting into other cells and have it reference the new column?
WHAT I WANT TO HAPPEN when I copy B and C into D and C or any other two columns is for the conditional formatting to target the "left" of the two columns and the 3rd cell respectively. In the sheet I posted below I have pasted it and if you right click into D3 and select conditional formatting you will see all the formats I set up are still references B3. By selecting "warlock" from the D3 drop down it should change the color to purple.
Any solutions to what I am trying to do would be great. Again my goal with the =$B$3="Warrior" formula is to recognize the word in the cell and color all the cells in B and C one color. If there is an easier way to do this please let me know.
Thank you so much for your time!
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Jan 30, 2020
couple of things ...
1) I suggest you share your spreadsheet with all Conditional Formatting removed
2) then explain what do you want to happen in cells B3 and D3
what is your requirement for Conditional Formatting Of these cells
don't offer a solution ... just your requirement
3) then taking one thing at a time
show your expected result
along with needed logic / explanation as to why that is the correct result
and then let us take it from there.
Cheers!
Yogi Anand
Original Poster Anthony Mascia marked this as an answer
All Replies (5)
Jan 29, 2020
couple of things ...
1) once you have your Conditional Formatting set up correctly for columns B and C
(your conditional formatting as currently set up for columns B and C can be simplified)
2) to copy the conditional formatting
from columns B and C
to columns D and E
select columns B and C
then do Edit > Copy
select columns D and E
then do Edit > Paste special > Paste conditional formatting only
I hope this helps.
Cheers!
Yogi Anand
Jan 29, 2020
the reason I am using =$B$3="WARRIOR" as a formula is because that is the only way I could figure out how to fill all the cells B2:C
If there is another way to use conditional formatting to fill all the cells from B2:C based on the value that is in cell B3 I think that would fix everything.
Jan 29, 2020
couple of things ...
1) I suggest you share your spreadsheet with all Conditional Formatting removed
2) then explain what do you want to happen in cells B3 and D3
what is your requirement for Conditional Formatting Of these cells
don't offer a solution ... just your requirement
3) then taking one thing at a time
show your expected result
along with needed logic / explanation as to why that is the correct result
and then let us take it from there.
Cheers!
Yogi Anand
Original Poster Anthony Mascia marked this as an answer
Jan 30, 2020
I have created the sheet labeled No Conditional Formatting.
1. I would like to conditionally format B3 so that it will color in all the cells in columns A and B yellow when B3 contains the word Rogue.
2. Because I will be adding many other names to this sheet ie BBQ and they have different classes rather than recondition each time i add someone I would like to copy columns AB and paste them so that the conditions I have created carry over looking at the 3rd cell in the left of the two columns. In BBQ's example his class is a warrior and I would like to fill all the cells in D and E with a light brown color.
In the example I previously posted you will see all the classes and colors I and trying to condition. If i could successfully paste AB with the conditions following the new cells I would be good to go.