Conditional Formatting help
Conditional Formatting help
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Conditional Formatting help

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

    Default

     
    Hiya,
    I'm pulling my hair out hair trying to get this problem fixed to no avail

    I have 5 columns with product prices... Lets say E2 (our price) - F2, G2, H2, I2 (competitors prices)

    What I want to do is if the figures in columns F,G,H or I is equal to or less than our price in column E make the figure go red.

    I am able to do this for a single cell but It would take me years to format every cell individually as there are over 2000 rows. I keep getting an error when trying to select an entire column.

    Please help

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:

    select F2, go to Format > Conditional Formatting, under Condition 1 select Formula Is, then enter =F2<=E2 in the field to the right.

    Click the Format... button, select the Patterns tab, red color, OK, OK.

    Now as a shortcut to copy this conditional formatting, select F2 and drag to highlight from F2 to F2000 (your competitors). With that range highlighted, click Format > Conditional Formatting, OK. Repeat for other columns.

    Any help?

    _________________
    Tom Urtis

    [ This Message was edited by: Tom Urtis on 2002-04-01 20:06 ]

  3. #3
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The above should read:

    Try this:

    Select F2, go to Format > Conditional Formatting, under Condition 1 select Formula Is, then enter =F2<=E2 in the field to the right.

    Click the Format... button, select the Patterns tab, red color, OK, OK.

    Now as a shortcut to copy this conditional formatting, select F2 and drag down to highlight from F2 to F2000. With that range highlighted, click Format > Conditional Formatting, OK. Repeat for other competitors' columns, modifying the formula accordingly.

    Any help?

    _________________
    Tom Urtis

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

    Default

      
    Thaaaaaaank You !
    It worked like a charm

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