Results 1 to 13 of 13

More than 3 conditional formats?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    More than 3 conditional formats?

    I made a spreadsheet for scheduling employees. I often grant leave (vacation, sick, etc...etc...), and fill the open positions. I have about 7 different variables. Conditional formatting works great, but for only 3 of the 7 variables.

    I'm looking to fill the cell color and change the font color when I enter
    certain text into the cell, including empty cells.

    for instance...if a cell is empty - color =red
    cell has "AL" - color=blue, text=white.
    and so on....and so on - 7 different variables.

    I don't need every cell in the worksheet to do this, I need this to work in 4 different cell ranges.

    Is this possible?

    JF
    Last edited by Ltat42a; 01-04-2006 at 09:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1