Results 1 to 17 of 17

Thread: Can someone explain these CF formulas to me

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    VBAX Regular
    Joined
    Sep 2015
    Location
    East Texas
    Posts
    87
    Location
    This is in my Conditional formatting:

    '=IF(AND($I$19="E",ISODD($AX2)),1,"") (Range) $AI$2:$AI$56

    When you place a E in I19 how does it know to take away certain numbers in column AI? You can remove the E from I19 and the cells in column AI will go back to black. Place a E or O in any of the cells in columns IJ that they will take a way certain numbers in AI:AN

    I want to know what tells AI:AN to black out certain numbers (hope this makes sense)

    Hopefully you can help me out and if you need additional info let me know or sheets but most of all THANK YOU for helping or if this is going to be too much to deal with please let me know as I know time is valuable to all
    Attached Files Attached Files

Posting Permissions

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