Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

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


1 - 4 of 4
<<PREVIOUS 1 NEXT>>