Results 1 to 6 of 6

Use Conditional Formatting When Reference Cell Not Blank

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    Emporia, KS
    MS-Off Ver
    Excel 2000
    Posts
    5

    Use Conditional Formatting When Reference Cell Not Blank

    I am using conditional formatting to change the fill color of a cell if the value does not equal a reference cell. The problem I am having is that the reference cell will be blank after data is entered into the cell with the conditional formatting. Obviously, when the data is entered the two cells are no longer equal and it changes color based on the condition being true (blank<>data entered). How can I keep it from changing color if the reference cell is blank or only allow it to change color if the reference cell has data entered in it?
    Last edited by damalco; 07-09-2010 at 10:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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