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

Thread: IF statement not working - I'm using .xlsx file

  1. #11
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    41
    Articles
    0
    Excel Version
    1901

    Also - conditional formatting



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

    I wanted to add this image as well, for some reason 2 of the 4 conditional formatting rules are not working? Status (yrs), H works off of Days Left, G. 2 of the formats that I setup are not working, yet the formula is correct in all cells and the same value in the conditional rule.
    Attached Files Attached Files

  2. #12
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,620
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by bobjglover@gmail.com View Post
    the challenge with this is I am unable to call out "between"? for instances I am hoping to identify contracts that are 30 days and under as" Very Near/Yellow" and 30-90 days "Getting Close/Orange" and the remainder over 90 "Ok/Green"?
    Try the formula on numbers from 0 to 40 and you'll find that 'between' is catered for:
    Click image for larger version. 

Name:	2019-12-10_220655.jpg 
Views:	6 
Size:	51.5 KB 
ID:	9485


    A workbook rather than pictures of a workbook is infinitely preferable.

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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