+ Reply to Thread
Results 1 to 1 of 1

Help needed with conditional formatting

  1. #1
    Forum Contributor
    Join Date
    10-20-2005
    Posts
    127

    Help needed with conditional formatting

    I think that no one is able to understand my question properly.(because i am not able to explain it properly)here i am once again asking it in a different way.My problem is that, that i want to ignore blank i mean i had set a conditional formatting say

    A B C D
    24.9 25.9 25 25.8
    22.6 23.4 22.5 23.3

    If value in ColA is less than value in ColC, cell A1 is shaded blue OR if
    value in ColB is greater than value in ColD, cell B1 shaded blue.

    I have done above formatting but my problem is that if i dont enter anything in colC then also colA is shaded in blue similarly if i dont enter any value in colD then also col B is shaded.I mean i want to ignore the blank.I need , if col C is blank then the Col A must be normal .& if col D is blank & i enter any value in colB col B must be normal.I want to ignore blank.What should i do ?


    Thanks in advance.


    Thanks in advance.
    Last edited by Little Master; 04-05-2006 at 06:18 AM.
    Regards,
    Little Master

+ 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