Forum Discussion

StevenCohen's avatar
StevenCohen
Copper Contributor
May 12, 2020
Solved

Conditional Formatting Formula Changes Erratically

I am trying to format a cell if it is not equal to another cell, but the formula I type in changes itself. Here is what I did, starting with a blank sheet. typed x into A1 typed y into A2 clicked...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 12, 2020

    StevenCohen 

    Forgot to say, it's when changing the range we move reference in the formula out of the sheet. If modify my pervious example, start the rule from cell A17 with formula =A11>2 and after that apply the range to =A11:A15 when reference in the formula will be changed on =A5>2, i.e. on 6 rows up.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 16, 2020

Paul00 

In Apply to are always absolute references. Why don't you apply the rule to $B$1:$P$30?

Paul00's avatar
Paul00
Copper Contributor
Jun 16, 2020

SergeiBaklan 

Thanks, I thought I tried everything. I was trying to copy the formula into the adjacent cells with the fill handle, but I see I didn't need to do that.

 

Paul

Resources