Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN...
Answer Question
| Jun 24 2008 10:39 AM GMT
| asked by
Nichalos82
Access, Database, Conditional formatting
Changing Color in a Cell
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...
View Answer
| Jun 19 2008 12:06 AM GMT
| asked by
Kioh46
Conditional formatting, Excel 2003, Microsoft Excel
Cell Colors in Excel
I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.
View Answer
| May 30 2008 2:18 PM GMT
| asked by
TweetyBird69
Excel macros, Microsoft Excel, Conditional formatting
coloring rows “if” true
I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...
View Answer
| May 16 2008 8:17 PM GMT
| asked by
Tstychalski
Excel 2003, Conditional expressions, Microsoft Excel
