Results 1 to 3 of 3

Cancel Conditional Formating if cell not empty

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    Arizona
    Posts
    28

    Cancel Conditional Formating if cell not empty

    Hey all,
    I am trying to have conditional formatting of cells apply only if another cell is blank in 2007.

    A3 has a formatting of =MOD(ROW(),2)=1, then =AND(A3<>"",A3+15<=$G$1) to change the color based on date and finally =AND(A3<>"",A3+30<=$G$1) to again change the color again by date.

    What I would like to do is for the cells in columb A to change only if corresponding columb B cell is empty, without using macros if possible.
    Attached Files Attached Files
    Last edited by wcnwzrd; 08-11-2009 at 12:38 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