Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Spreadsheet reference help
I've been working on a work schedule for which one spreadsheet references another. Is there anyway to get the spreadsheet/cell info to auto-update. I have to do the schedule in a two week format. The formula I'm using (Thanks again Skip) is as follows: =IF(WhatInteriorColor('[ANCILLARY...- waladd
- Thread
- Replies: 7
- Forum: Microsoft: Office
-
Trying to use an IF formula w/ Colored Cell
I'm trying to create a formula that reads the cell background color and reports a specific answer for that cell. My Human Resources department needs the employee schedule one way, while my employees are use to looking at it in a totally different format. HR uses a color key to code whether...- waladd
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Trying to use an IF formula w/ Colored Cell
I'm trying to create a formula that reads the cell background color and reports a specific answer for that cell. My Human Resources department needs the employee schedule one way, while my employees are use to looking at it in a totally different format. HR uses a color key to code whether...- waladd
- Thread
- Replies: 5
- Forum: Microsoft: Office
