Till Total 300 600 310 (sum three cells)
Tape Total 1200 (merged cell)
Differ 10 (merged cell)
I tried the conditional formatting but have had troubles with the blue condition.When i put the suggested formatting in, regardless of a positive or negative number, it was red. I don't know much about excel so i am more than likely making an error somewhere. Further help would be much appreciated.
I want to get the following in my spread sheet.
Condition 1: =SUM(Till Total) < Tape Total ..... if not the differ number should be red
Condition 2: =SUM(Till Total) => Tape Total .... if yes the differ number should be blue
Please help.