I’m doing a project for my manager, and I have made a spreadsheet which basically predicts figures throughout the month. Only issue is he said he finds it hard to read.
Basically, I have formulas in that based on today’s figures will carry on throughout the month.
I want to put a format on, that even though these cells are already filled out through a formula, I want them to turn white when I manually write in anything, almost to highlight the day were on. Is this possible?
So eg 6th, 7th, 8th 9th, 10th ect is all grey, but has information in it from formulas - when I get to the 6th and add that days information, when I manually write in the information it will go white. I hope this makes sense, I don’t even know if this is possible but I can’t find anything to help me.
Thanks so much
