+ Reply to Thread
Results 1 to 2 of 2

conditional formatting using IF with MID functions

  1. #1
    Registered User
    Join Date
    11-20-2007
    Posts
    4

    conditional formatting using IF with MID functions

    okay, I have a sheet with a bunch of skus, ie "MCREADER". If i have none in stock, I want it to be red. I will indicate that I have none in stock by putting a zero as the first character. So the sku would then be "0 MCREADER".

    Now, I select that cell "C11" in this case. Go up to conditional formatting. And use the formula:

    Please Login or Register  to view this content.
    Select the background to be red.

    But nothing happens. Is there something wrong with my formula.

    Also, how would apply this to all the cells on the sheet. How do i copy & paste the conditional formatting to apply for all the cells, that i set up for that one cell.

    If there's a better way to do this, please let me know.
    thanks for any help in advance.

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    jdubwelch

    Welcome to excelforum

    Please read forum rules and post your thread in the correct forum
    Programming Forum is for VBA macro type questions/problems

    A thread with the rules is available at the top of each forum or see link below for rules
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ 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