Forum Discussion
Is it possible to format the fill color of a cell to equal the fill color of another cell?
I have a spreadsheet with with columns conditionally formatted to fill (highlight) based upon the text of another cell. For example, the formula in C3 is '=$E$2', and if E2 contains "STS" the Condi...
I'm sorry, but I am not able to do that. The question is, can I use CF (or another method) to highlight J16 BECAUSE J15 was highlighted through CF?
OR
Highlight [J15(+2 cells to the right)] without having to do it manually?
OR
Highlight [J15(+2 cells to the right)] without having to do it manually?
It can probably be done, but without seeing a copy of the worksheet and the conditional formatting rules it's impossible to know for sure.