Conditional Formatting – Excel 2007
Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. [...]

Answer Question   |  October 21, 2010  7:19 AM
Conditional formatting, Excel 2007, Excel Formatting, EXTEND mode, Office 2007, Windows XP

VBA format a cell based on range contents
I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. ‘assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As [...]

Answer Question   |  May 20, 2009  5:11 AM
*RANGE, Conditional formatting, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

Conditional formatting in Microsoft Excel 2003
Basically I have 2 columns the first column has years in it & the second has random letters. Now, going down the 1st column it reads: 2007,2007,2007,2007,2007,2008,2008,2008,2009,2009,2009,2009 And going down the Second Column it reads: A,B,A,B,B,B,A,B,A,A,A,B Note: This is just a segment of the data table. What i need is formula that will answer the [...]

Answer Question   |  May 13, 2009  6:59 AM
Conditional formatting, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2003 formulas

Excel 2003 – conditional formatting
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]

Answer Question   |  February 26, 2009  1:30 PM
Conditional formatting, Excel 2003, Microsoft Excel

Excel 2003 – Conditional Formtting Help
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]

Answer Question   |  February 23, 2009  7:25 PM
Conditional formatting, Excel 2003, Microsoft Excel

Conditional Formatting Excel 2003
I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and “IF” statement on columns 2 and 3. Stating if column 2 is after or 1 month from today’s date highlight in RED. And column 3 should state [...]

Answer Question   |  February 20, 2009  5:26 PM
Conditional formatting, Excel 2003, Microsoft Excel

Conditional Formatting – Excel 2003
Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and “eguals the company in [...]

Answer Question   |  February 10, 2009  8:20 PM
Conditional formatting, Excel 2003, Excel Formatting, Microsoft Excel

Formatting a spreadsheet row with color
hello, I would like to know if there is a way to color (shade in) a row when one specific cell has a value in it. For instance if I am entering in data and column I is for refunds, when that i blank i dont want the row to be shaded, but if there [...]

Answer Question   |  November 10, 2008  11:55 PM
Conditional formatting, Spreadsheet formulas, Spreadsheets

Conditional Format – Access 97
Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form’s background color based simply on whether the record is “Active” vs. “Inactive.” Thanks, [...]

Answer Question   |  October 30, 2008  6:07 PM
Access 97, Conditional formatting, Microsoft Access

Conditional formatting
How do I get conditional formatting in a form to continue to work as a sub form

Answer Question   |  October 21, 2008  10:55 AM
Conditional formatting, Microsoft Office, VBA, Visual Basic for Applications

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 DATE()- 90=greenfont) [...]

Answer Question   |  June 24, 2008  10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access

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 [...]

Answer Question   |  June 19, 2008  12:06 PM
Conditional formatting, Excel 2003, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications

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.

Answer Question   |  May 30, 2008  2:18 PM
Conditional formatting, Excel macros, Microsoft Excel

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 [...]

Answer Question   |  August 14, 2008  8:17 PM
Conditional expressions, Conditional formatting, Excel 2003, Microsoft Excel