Trying to use an IF formula w/ Colored Cell 1

[waladd]

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 someone is sick, on in one area or another etc. The colors are listed in excel as Red, Rose, Light Green, Light Yellow. These schedules are in two different workbooks. I'm using Office 2003 Pro.

 

[SkipVought]

Hi,

Are they shading the cell explicitly or using Conditional Formatting?

If they are using Conditional Formatting, then there is a way to do this with shreadsheet functions.

Otherwise, you're stuck with VBA Code. In this event, please report in VBA Visual Basic for Applications (Microsoft) Forum707.

Skip,

_[red][/red]

 

[waladd]

Using color fill, so cell shading I guess?

 

[SkipVought]

Guessing won't cut it.

Select one of the shaded cells and Format/Conditional Formatting...

Is there a formula in the Conditional Formatting Window?

Skip,

_[red][/red]

 

[waladd]

No format set.

 

[SkipVought]

Then you are stuck with the latter approch.

Skip,

_[red][/red]