Forum Discussion

Copper Contributor

Oct 02, 2017

Conditional formatting with adjacent cells

Hello! I have a spreadsheet with continously expanding rows. I want to create one column that has conditonal formatting with its corresponding adjacent cell. The format painter doesn't work becau...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Oct 03, 2017

Hi James,

I see. The workaround is to use offset, which gives the reference on next column and current row. Not sure what's your formula, could be like

=0.67*OFFSET($J$3,ROW()-3,0,1,1)

and apply it to your entire range. row()-3 returns first row in your range.

SergeiBaklan

Diamond Contributor

Oct 03, 2017

Forgot to say, with this you shall apply your rule only to first cell in the range (I3), aplly to next ones by format painter

James Urbanski
Copper Contributor
Oct 03, 2017
Works great!! Thank you.
There will be an issue in the future, as this is going to be used as a continous log, when rows are added, that column will need to be "repainted" from the top cell, for the equation to be consistant. -But, that is another conversation, for another day.
Thank you very much!!
- SergeiBaklan
  Diamond Contributor
  Oct 03, 2017
  James,
  
  You are welcome. When you are ready with new question better if you attach small sample file, will be easier to discuss.
  Thank you