Forum Discussion
Copying Conditional formatting with relative cell referencces in the formula desn't work
I have a cell H19 conditionally formatted "Format values where this formula is true" with: ="h19>$C$19" and then the colour green When I copying the cell with Format Painter to cells H20 to H90, the...
I know this is an old thread, but for anyone reading - I found that I was unable to copy the formatting to more than one cell at a time. The Format Painter will work copying the conditional formatting with relative cell references from, for example, cell T3 to cell T4, however, if I drag the Format Painter down cells T4 through T14, it will only use relative cell reference for T4 but not the other cells.
I think this is a feature that could use some work, if anyone else knows a way around this please let me know.
I have the same issue and frustration with the Format painter solution offered.
I want one cell in Sheet A compared to one cell sheet B and color changed if sheet A cell is > Sheet B cell.
The PAINTER solution applies a fixed reference to the range you paint it across. I know I can do it one at a time, but I have almost 400 cells in the BUDGET to compare against forecast.
Same frustration as several others above detail.
If you compare cell to cell it shall work. Let say you apply CF to first cell only
after that double click format painter and drag the mouse over the rest of range - it'll be like
SergeiBaklan I want the original (top left) cell to move relatively, not be fixed. Let me try the way....
I have two sheets in the spreadsheet, each contains an identical BUDGET . (12 MOnths across top and 30 budget categories along the left side.)
They are identical now when I create the budget, but one will be used to record ACTUAL expenses as the year progresses. I want to use COnditional Formatting on each cell, to highlight when that cells amount exceeds (>) the Budget Sheet's value for that same cell.
I use formula =D15>(BUDGET!$D15*1.05) and then highlight red.When I use Format Painter across a row or column, EXCEL fixes that original D15 reference.
I want the test cell reference to change relatively too.Does this explain my question, is there a solution for me? I am now doing in manually one cell at a time.
I tried using =D15>(BUDGET!D15*1.05) too. It copies the D15 cell reference as the test, instead of changing relatively.
