Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Conditional formatting using formulas referencing another worksheet

I’m new to LibreOffice. I have a huge spreadsheet that I made in excel 2010 but need it to function in Calc since many of those that will use it have Libre on their machines. Many of my conditional formats didn’t transfer so I’m working feverishly to understand the differences in Calc

I have a conditional formula in excel that is =AND($C10=“Combining two cases”,’FNL LIMIT’!$C9=“”) If C10 on the current sheet says Combining Two cases and C9 on the other worksheet FNL LIMIT is blank A12 turns brown and so they can see the warning message I have built in white font

Once the cell on the FNL LIMIT worksheet is filled in the brown needs to go away. I can’t for the life of me get this to work in Calc. It works beautifully in excel but Calc i cannot get it.

I can get the A12 cell to turn brown if C10 on the shert I’m on says Combining two cases. The problem is when C9 on the other sheet is filled in, it is still brown and doesn’t turn off.

Please help me figure this one out. I know I’ll have several more as I test this workbook in Calc.

Thank you!

Conditional formatting using formulas referencing another worksheet

I’m new to LibreOffice. I have a huge spreadsheet that I made in excel 2010 but need it to function in Calc since many of those that will use it have Libre on their machines. Many of my conditional formats didn’t transfer so I’m working feverishly to understand the differences in Calc

I have a conditional formula in excel that is =AND($C10=“Combining two cases”,’FNL LIMIT’!$C9=“”) If C10 on the current sheet says Combining Two cases and C9 on the other worksheet FNL LIMIT is blank A12 turns brown and so they can see the warning message I have built in white font

Once the cell on the FNL LIMIT worksheet is filled in the brown needs to go away. I can’t for the life of me get this to work in Calc. It works beautifully in excel but Calc i cannot get it.

I can get the A12 cell to turn brown if C10 on the shert sheet I’m on says Combining two cases. The problem is when C9 on the other sheet is filled in, it is still brown and doesn’t turn off.

Please help me figure this one out. I know I’ll have several more as I test this workbook in Calc.

Thank you!