A Nice Easy One (Hopefully!)
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: A Nice Easy One (Hopefully!)

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I could not duplicate this happening (blank did not trigger conditional formatting). Are you sure the cell is otherwise empty?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nick greater than 9.6 works for me, anything above 9.6 changes the cell condition anyhing under does not

    On 2002-03-14 07:25, Mr Nick wrote:
    I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It contains a formula:

    =IF(G12="","",IF(G12="FIXED POWER",SUM(((T12*C12*K12)/1000)+U12),IF(G12="LIGHTING",SUM(((T12*C12*K12)/1000)+U12),IF(G12="RING MAIN",SUM(((T12*C12*K12)/4000)+U12),"Cct Type!"))))

    Which, if certain cells are not filled in, leaves this conditionally formatted cell blank. If it left blank, the cell gets formatted but if value is entered above 0 the formatting works. I've tried adding a second condition for a zero value but this doesn't work either??

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    Glasgow
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [quote]
    On 2002-03-14 07:25, Mr Nick wrote:
    I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?
    [Hi Mr Nick,
    You require to set the first value on the conditional formatting equation to equal 9.6 = no format and then set a second condition of greater than


    ]

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That doesn't work. It still formats the cell in red if it is blank.

  7. #7
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    799
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just select

    "Formula is"

    in conditional formatting then use this for formula

    =AND(ISNUMBER(B3),B3>9.6)

    (=AND(ISNUMBER(B3);B3>9,6) if you are using , for decimal seperator in your system)

    B3 is the cell reference

    regards
    suat
    (You can visit TheWordExpert for VBA help and also other office applications)

    [ This Message was edited by: smozgur on 2002-03-14 08:02 ]

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You might try setting the conditional formatting to Formula Is =(your formula)>9.6

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Smozgur - That's done it.

    Cheers Everybody.

  10. #10
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    799
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Nice to hear that

    suat

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com