dgoldfluss
asked on
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.
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,
Damir
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
not really the answer i needed