Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Conditional Format Once Again......

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Q: Is there a conditional format that will change the highlighted range of cells formatting (i.e. cell color) when the cell P7 (indicated by the red arrow) is above or below a specific value? Also , I will need to be able to apply that to every row and the corresponding cell. Thanks! Davin Brown



    [ This Message was edited by: davin on 2002-04-01 12:49 ]

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry about the HUGE image, I fotgot that I run Extremly high resolution!

  3. #3
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I can't see your image, but you can definitely do what you want to do. For example highlight the row you want to highlight then goto Format|Conditional Formatting|Select Formula Is from the drop down menu|enter in your condition, something like, =OR($P$7<8,$P$7>9)|select your format
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If for some reason the Image doesnt load, here is the URL http://www.geocities.com/davinbrown/image001.png

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-01 13:18, davin wrote:
    If for some reason the Image doesnt load, here is the URL http://www.geocities.com/davinbrown/image001.png
    Davin,

    It doesn't clarify your query (for me): You said:

    Q: Is there a conditional format that will change the highlighted range of cells formatting (i.e. cell color)
    when the cell P7 (indicated by the red arrow) is above or below a specific value?
    Also , I will need to be able to apply that to every row and the corresponding cell.


    What values for P7 do you have in mind? More importantly, what do you mean by: "every row and the corresponding cell"?

    Aladin



    [ This Message was edited by: Aladin Akyurek on 2002-04-01 13:35 ]

  6. #6
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Still can't see your picture (page not found). Does my post help?

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I appologize, I have the problem solved now.

    Thanks!

Some videos you may like

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
  •