Hey guys, I am trying to get the cells in column C to to 'fill' red if -1, and green if 1.
I have trying this with the conditional formatting but havent had any success, can some help me understand what's tripping me up?
I had tried to format the cell fill and the font format to be the same color, but that didnt work.
Any help would be greatly appreciated, please see the attached file for better clarity. Thanks a ton.
CondFormat Help.xlsx
Bookmarks