User Profile
erictmtl
Copper Contributor
Joined 11 months ago
User Widgets
Recent Discussions
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/m-p/3867038#M197140 I will like a cell to be green>0 red<0 based on the value of cell below it. I can manually do it but I will have to do it hundreds of time. This is what I tried to do. What is happening at the moment, the row change color base on A3 value. In the small exemple I will like B2 and C2 to be red because B3 and C3 are negative
