Forum Discussion

Copper Contributor

Feb 16, 2020

Change color in Cell

Good afternoon,

I would like to do a following formula.

IF (Value A1>2000,COLOR CELL=RED, GREEN).

I do not want to use the conditional format caused the cell A1 can change.

Thanks in advance,

Ronan

3 Replies

SergeiBaklan
Diamond Contributor
Feb 16, 2020
rliebard

If not a secret, what's the reason for not using conditional formatting?
drvikasbhardwaj
Copper Contributor
Feb 16, 2020
rliebard
you can do with the help of helper cells by using =INDIRECT in define name & Paste link image which transparency 90%
- drvikasbhardwaj
  Copper Contributor
  Feb 16, 2020