Forum Discussion
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...
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.
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