Home

Excel 2013 Conditional formatted cell with Indirect function is not recognised by PDF/Printer

%3CLINGO-SUB%20id%3D%22lingo-sub-452582%22%20slang%3D%22en-US%22%3EExcel%202013%20Conditional%20formatted%20cell%20with%20Indirect%20function%20is%20not%20recognised%20by%20PDF%2FPrinter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-452582%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EDear%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20have%20created%20gantt%20chart%20with%20indirect%20function%20(because%20it%20pulls%20data%20from%20another%20sheet).%20The%20point%20is%20I%20had%20to%20do%20it%20in%20that%20way%20since%20second%20sheet%20working%20as%20database%20and%20it%20always%20changes.%20If%20someone%20remove%20row%20in%20that%20sheet%20or%20if%20it%20is%20empty%2C%20my%20formulas%20go%20crazy%20with%20error%20%23!Ref%20and%20I%20have%20to%20change%20everything%20manualy.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20want%20to%20use%20Macro%20for%20this%20operation%2C%20because%20indirect%20function%20doing%20excellent%20job.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%202013%20see%20everything%20fine%20and%20chart%20is%20working%20like%20a%20charm%2C%20but%20PDF%2FPrinter%20does%20not%20see%20exactly%20these%20Conditional%20formatted%20with%20Indirect%20function%20cells.%20I%20tried%20to%20remove%20Indirect%20function%20and%20it%20was%20visible%20on%20PDF%2FPrinter%20which%20means%20that%20Indirect%20in%20combination%20with%20CF%20is%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20solution%20to%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20help%20for%20my%20problem%20(old%20topic%20where%20nobody%20found%20solution).%20It%20is%20similar%20as%20mine%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fprinting-conditional-formatting-with-indirect%2Fd498e891-85f1-44f2-a787-2989fbda757e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fprinting-conditional-formatting-with-indirect%2Fd498e891-85f1-44f2-a787-2989fbda757e%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3E%C4%90or%C4%91e%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-452582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-453591%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202013%20Conditional%20formatted%20cell%20with%20Indirect%20function%20is%20not%20recognised%20by%20PDF%2FPrinter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-453591%22%20slang%3D%22en-US%22%3EI'd%20advise%20to%20rethink%20the%20way%20you%20refer%20to%20the%20other%20sheet.%20Perhaps%20you%20can%20use%20functions%20like%20INDEX%20and%20MATCH%20to%20get%20the%20data%20you%20need%20rather%20than%20using%20direct%20cell%20references.%20That%20way%20you%20can%20also%20sort%20the%20data%20wothout%20disrupting%20your%20references.%3C%2FLINGO-BODY%3E
drag1c
Occasional Visitor

Dear,

 

I have created gantt chart with indirect function (because it pulls data from another sheet). The point is I had to do it in that way since second sheet working as database and it always changes. If someone remove row in that sheet or if it is empty, my formulas go crazy with error #!Ref and I have to change everything manualy. 

I do not want to use Macro for this operation, because indirect function doing excellent job.

 

Excel 2013 see everything fine and chart is working like a charm, but PDF/Printer does not see exactly these Conditional formatted with Indirect function cells. I tried to remove Indirect function and it was visible on PDF/Printer which means that Indirect in combination with CF is problem.

 

Does anyone have solution to this?

 

Here is help for my problem (old topic where nobody found solution). It is similar as mine:
https://answers.microsoft.com/en-us/msoffice/forum/all/printing-conditional-formatting-with-indirect...

 

 

Best regards,

Đorđe

1 Reply
I'd advise to rethink the way you refer to the other sheet. Perhaps you can use functions like INDEX and MATCH to get the data you need rather than using direct cell references. That way you can also sort the data wothout disrupting your references.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies