+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting issue

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Conditional formatting issue

    Hello all -
    I am having an issue getting an conditional format to work correctly.

    My goal is to have it where if there is nothing in a particular field, that it stays white.
    For whatever reason, the blank field as shown in my attachment is coming up red.
    All the other fields in column O are working as needed. Just not sure why this is coming up red for cell O24.

    When there is a "0" in C24 & D24, O24 turns from red to white and works ok.
    Just not sure why if C24, D24 AND 024 are blank, why it would be red. I am sure it is something small....

    I have an attachment with screen prints showing my formulas and such.

    Any help would be appreciated.

    Thanks.
    Dave
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Conditional formatting issue

    1. Why are you posting in an Outlook forum?
    2, Why a docx attachment when in an XL solution is reuqired ?

  3. #3
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Re: Conditional formatting issue

    Pepe - I made a mistake and posted to the wrong forum.
    1000 apologies...

+ Reply to Thread

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