If/then w/cell color as value


Posted by Jane on August 09, 2001 3:31 PM

I am trying to create a work schedule with emp. shift represented as a formatted (color, pattern,etc) cell. I am trying to figure out a way to use if/then statments so that a "true" response would result in the formatting of a cell. Does this make sense?
Thanks for any/all help, Jane



Posted by Aladin Akyurek on August 09, 2001 3:39 PM

It seems you're looking for Conditional Formatting (under Format).

Aladin