Forum Discussion
Sun_Y650
Apr 11, 2021Copper Contributor
Calendar from excel data
Hi, m not very good with excel formulas, someone help me build this calendar from the data i have, which is extremely useful. However, now there's an additional requirement that the entry at the cale...
Sun_Y650
Apr 11, 2021Copper Contributor
NikolinoDE Hi thanks, but i need it in the formula referring to the other sheet like my calendar, eg. the GSS is red in Goods Coming sheet, then the GSS (1) should be red in Goods Coming Calendar sheet too.
NikolinoDE
Apr 12, 2021Platinum Contributor
Enclosed the files from B5 to B7 were conditionally formatted by me with the formula sent.
Only this has to be entered for each cell, so that when an entry appears the color changes immediately.
Try it with cell B7, insert the date value 04/05 in the worksheet "Good Coming" and it will appear exactly that way.
Enjoy Excel
Nikolino