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.
dgoldflussAsked:
Who is Participating?
 
geoffkkConnect With a Mentor Commented:
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.

Geoff
0
 
jppintoCommented:
Isn't that a Conditional Formatting?? That's why you don't find any code...
0
 
dkuticicCommented:
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,

Damir
0
 
dgoldflussAuthor Commented:
not really the answer i needed
0
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.

All Courses

From novice to tech pro — start learning today.