Tagged Questions
0
votes
0answers
14 views
OPEN OFFICE CALC - How do I use conditional formatting give me a background based on the distance from a date AND value of a cell?
If I have "Alpha", "Bravo" or "Charlie" in column "A" and "Annual", "Semi-Annual" or a blank cell in column "B", How can I use conditional formatting to change the background color of a cell in the ...
0
votes
0answers
288 views
How do I use conditional formatting in Open Office Calc to use an image for the background instead of a color?
Ok so we have a spreadsheet that we are trying to reproduce in Open Office Calc that was created in Microsoft Excel. The feature that we are trying to emulate is using an image instead of a background ...
1
vote
2answers
253 views
Advanced spreadsheet auto-formatting
Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 cells background becomes light gray
I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet
