I WANT THE COLOUM A1 TO SHOW “TRUE OR FALSE”
I HAVE THE NUMERIC VALUE =SUM (A2:A5)IN A6. IF THE VALUE IS ‘0’ I WANT THE WORD “TRUE” MUST APPER IN CELL A1 IN BLUE COLOUR AND IF THE VALUE IS ABOVE 0 FOR EXAMPLE (1 -100) IT MUST SHOW “FALSE” IN CELL A1 IN RED COLOUR. cAN I HAVE THE FORMULA FOR THE ABOVE MATTERS.
