1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

conditional format questions

Discussion in 'All Other Software' started by the_boss, Jul 6, 2008.

Thread Status:
Not open for further replies.
  1. the_boss

    the_boss Thread Starter

    Joined:
    Jul 6, 2008
    Messages:
    1
    Hi, I know how to do conditional format for distant cells, but the problem is I need more than 3 conditional format options I dont want to play with vbs. I need to know how to add many values to a condition formula.

    im pretty sure i am not clear so here's an exemple!

    if the cells in the column g is = to either "15 min break ?" or "lunch break?" the cell on the row where the "15 min break ?" or "lunch break?" need to be formated a specific way.

    if the cell in the column g is = to offline duties or anything else it need to be formated an other specific way.

    ive been able to have the formula to work with 1 source like 15 min break in condition 1 and on condition 2 the lunch break. i also been able to get the formula to look at a list but it take the info from the fisrt cell in the list and ignoring the rest of the list.

    can anyone help me!!!


    thanks
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/727836

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice