Page 2 of 2 FirstFirst 1 2
Results 11 to 17 of 17

Thread: Conditional format cells in a column based on a formula and 2 criteria

  1. #11

    Woops



    Register for a FREE account, and/
    or Log in to avoid these ads!

    HIT_2016.xlsmI'm so sorry. I forgot to take off the protection on the second Workbook.


    Quote Originally Posted by Pecoflyer View Post
    Protected sheet, no can do

  2. #12
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Try = and($B2>=(today()-90),or($F2="investigating",$F2="implementing"))

    (don't forget B52 contains a text string...)

  3. #13

    random?

    HIT_2016.xlsm
    I am not quite sure what that did but it seemed to highlight dates randomly....

    Quote Originally Posted by Pecoflyer View Post
    Try = and($B2>=(today()-90),or($F2="investigating",$F2="implementing"))

    (don't forget B52 contains a text string...)

  4. #14
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Like this

    HIT_2016(1).xlsm

  5. #15

    um....

    This is incorrect. It highlights way more than 90 days overdue.

  6. #16
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Find someone else to solve this. Good luck

  7. #17

    Thanks!

    Thanks for trying!

Page 2 of 2 FirstFirst 1 2

Tags for this Thread

Posting Permissions

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