1
vote
0answers
54 views

Conditionally generate Excel sheet

I currently have an excel sheet that is used to record daily a bunch of parameters. Currently, I have a folder for each year, containing a folder for each month, inside of which I have an excel file ...
1
vote
2answers
331 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
2
votes
1answer
2k views

How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...
2
votes
1answer
165 views

Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1. ...
13
votes
2answers
4k views

Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...