Forum Discussion
erictmtl
Feb 14, 2024Copper Contributor
Color coding base on cell below
Hello I have read this thread and its working but what I'm trying to do is a little bit different https://techcommunity.microsoft.com/t5/excel/color-coding-a-cell-based-on-the-value-of-another-cell...
OliverScheurich
Feb 14, 2024Gold Contributor
=A3>0
=A3<0
These rules for conditional formatting work in my file.
=$2:$2
This is the range the format applies to in the example.