Results 1 to 13 of 13

conditional format has me stumped

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2011
    Location
    martinsburg, west virginia
    MS-Off Ver
    Excel 2003
    Posts
    20

    conditional format has me stumped

    I have been working on a conditioning format that looks right but when its entered it returns what im not asking it to do. Here are 3 pictures of the 2 different pages im using. What im trying to accomplish is if Clinker worksheet column C equals Hi Alk and column R is between the values of ISO page H13 and K13 i want column R to fill in green. Here is what i have but it shades green only some values between and even values outside of range. =AND($C7="Hi Alk",$R7>=ISO!$H$13,$R7<=ISO!$K$13)
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by frdranger25401; 03-20-2015 at 03:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 02-24-2015, 02:58 AM
  2. [SOLVED] Conditional Formatting - I'm stumped!
    By Diogie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2013, 07:19 AM
  3. Replies: 3
    Last Post: 05-15-2013, 12:16 AM
  4. Conditional Formatting with Form Controls. I'm stumped
    By DAC_LCS in forum Excel General
    Replies: 2
    Last Post: 05-24-2012, 11:03 AM
  5. Replies: 0
    Last Post: 05-20-2011, 02:33 PM

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