Hey everyone, thanks for all the help, I've used this forum a lot but never posted. I've searched high and low and can't find an answer to my problem so I thought I would post!
I have data in 2 columns, we'll say A and B, both with numbers only. All of the data in Column A has a straight forward conditional format to fill the cell with Red, Green, or Yellow based on what number it is. I want to automate (formula, conditional format, etc) the data in Column B to say: "If the cell directly next to you in Column A is Yellow, then also turn this cell in Column B Yellow".
E.g. Cell A4 is 15, so the conditional format turns it Green. Cell B4, regardless of what data is in it, needs to automatically turn green because Cell A4 is green. Obviously I want this to be repeatable for many more cells in a larger data set......
Thanks for any help you can offer!
Andy
Bookmarks