• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Excel programming question

II am trying to help a friend with an Excel 'database' that her IT person created and then left her. There are a number of sheets that are linked to other sheets. The issue i am finding is that there some programming that will change the color background of a cell when a condition is created in a different sheet. I do not know where this procedure or macrowould reside, it is not showing up in the code for either sheet. This shading is blocking the number that is linked to the cell.
1 Solution
Isn't that a Conditional Formatting?? That's why you don't find any code...
Conditional Formating. This you can find at Format->Conditional Formatting (Word 2003) or Styles->Conditional Formatting (Word 2007). Before start CF, you have to chose cells.
Example: if you want every second colored row you have to create Condition with formula =mod(row(),2) and chose color in format.
You can search for condition formatting through Find->Conditional Formatting, too.

Hope I help,

Select the cell which changes colour and click on Conditional Formatting. Depends on Excel version - in Excel 2007 you use the Home tab in the ribbon, Conditional formatting, Manage Rules. This will show whether there is conditional formatting applied and what it links to.

In Excel 2003 use Conditional Formatting on the Format menu.

dgoldflussAuthor Commented:
not really the answer i needed
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now