I AM CREATING A TRACKING LOG. THE FUNCTION I AM USING IS
=IF(A1-D35,"LATE","ON TIME") . A1 IS THE "NOW" FORMULA AND IS MY FIXED
POINT. I WANT IT TO READ THAT IF THE DATE ENTERED IN A SEPARATE COLUMN IS
GREATER THAN 5 DAYS IT IS LATE. HOW CAN I FOMAT AN ENTIRE COLUMN WITHOUT
GOING BLOCK BY BLOCK? WHEN I COPY AND PASTE, I HAVE TO CONSISTENTLY CHANGE
IT TO READ A1, BECAUSE IT WILL REVERT TO WHATEVER LINE I AM ON (A2, A34,
ETC.). i JUST WANT IT TO READ A1. AND IF I CAN GET THE "ON TIME" OR "LATE"
TO POP UP IN GREEN OR RED, THAT WOULD BE AWESOME!!!