Results 1 to 4 of 4

3 Conditional Formatting - 3rd one not working ?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    3 Conditional Formatting - 3rd one not working ?

    Here is what I have ...

    I have 3 CF's in Column G:

    =AI577>14 turn cell red

    =AI577=0 no color

    =AL577>14 turn cell red


    Cell AL577 is populated but the following IF Statement:

    =IF(G577="",$AK$1-E577,0)

    For the purpose of testing ...

    G577 is blank
    AK1 has a date of 12/06/19
    E577 has a date of 12/06/04
    So AL577 is 15

    Cell G577 is not turning red ?

    The first 2 CF work ... the 3rd not so much?

    Thoughts?
    Last edited by SVTF; 06-06-2012 at 11:41 PM.

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