Calendar from excel data

%3CLINGO-SUB%20id%3D%22lingo-sub-2266584%22%20slang%3D%22en-US%22%3ECalendar%20from%20excel%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2266584%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20m%20not%20very%20good%20with%20excel%20formulas%2C%20someone%20help%20me%20build%20this%20calendar%20from%20the%20data%20i%20have%2C%20which%20is%20extremely%20useful.%20However%2C%20now%20there's%20an%20additional%20requirement%20that%20the%20entry%20at%20the%20calendar%20be%20red%20should%20one%20of%20the%20items%20coming%20in%20the%20Goods%20Coming%20sheet%20is%20red%20too.%20Can%20anyone%20help%20me%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2266584%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2266605%22%20slang%3D%22en-US%22%3EBetreff%3A%20Calendar%20from%20excel%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2266605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1022912%22%20target%3D%22_blank%22%3E%40Sun_Y650%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EConditional%20formatting%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENew%20rule%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EUse%20formula%20to%20determine%20which%20cells%20to%20format%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%24B%245%26lt%3B%26gt%3B%22%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESelect%20the%20fill%20color%20and%2C%20if%20desired%2C%20the%20font%20color.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 calendar be red should one of the items coming in the Goods Coming sheet is red too. Can anyone help me please?

3 Replies

@Sun_Y650 

 

Conditional formatting

New rule

Use formula to determine which cells to format

 

=$B$5<>""

 

Select the fill color and, if desired, the font color.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

@Nikolino 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.

@Sun_Y650 

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