How to use value from one cell into another cell's "Conditional format rules "-CodePudding

Home > Enterprise > How to use value from one cell into another cell's "Conditional format rules "

How to use value from one cell into another cell's "Conditional format rules "

Time：04-15

I'm trying to set Conditional format rule on cell Y1 based on value of cell X1.

e.g. If Y1 cell value > value in X1 then set particular color.

But I am not getting which formula to use to get value from X1 cell

CodePudding user response：

Simply use `=X1` with the format rule `greater than`:

The important point is to to use = to indicate that you are refering to a cell in the spreadsheet.
See also