Hello!
I've attached an example of a sheet similar to what I'm actually working on and here's what I'm trying to do...
In Cells D2, F2, H2, J2, etc you will see a serial number such as "001A"
I want to conditionally format these cells to either green or red.
For D2 I want to turn the cell Red IF(SUM(D4:D56)<SUM($B$4:$B$56))
Vise Versa, I want D2 to turn Green IF(SUM(D4:D56)>=SUM($B$4:$B$56)
Survival Kit List Sample.xlsx
Any help is greatly appreciated. I've been strugglin with this for a couple hours now :/ Just can't seem to get it right....
Bookmarks