Forum Discussion

James2185's avatar
James2185
Copper Contributor
Dec 01, 2020

Conditional Formatting

Hi All,

Is it possible to conditional format a cell to change colour when it is less than half of another cell. For example.

Cell A1 total is 11
Cell A2 total is 25

I want A1 to colour red if it is less than half of cell A2.

Hope that makes sense.
Thanks

6 Replies

No RepliesBe the first to reply

Resources