+ Reply to Thread
Results 1 to 2 of 2

Conditional formating-change in 100 cells

  1. #1
    Guest

    Conditional formating-change in 100 cells

    Can I use conditional formatting so as to look at Column A

    A1 a2 A2 Turns
    EA 1.00 red
    CS 100 Blue
    BX 50 Green

    I have columns with 1000's of entries, and I may change column A1 entries
    often.

    Thanks in advance

    Harry



  2. #2
    Bob Phillips
    Guest

    re: Conditional formating-change in 100 cells

    Sure, select column A, goto Format>Conditional Formatting

    Change Condition to Formula Is
    Input a formula of A1=1
    Click Format, select the pattern tab and choose Red
    OK
    Add condition
    Change Condition to Formula Is
    Input formula of A1=50
    Click Format, select the pattern tab and choose Green
    OK
    Add condition
    Change Condition to Formula Is
    Input formula of A1=100
    Click Format, select the pattern tab and choose Blue
    OK
    OK


    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    <[email protected]> wrote in message
    news:[email protected]...
    > Can I use conditional formatting so as to look at Column A
    >
    > A1 a2 A2 Turns
    > EA 1.00 red
    > CS 100 Blue
    > BX 50 Green
    >
    > I have columns with 1000's of entries, and I may change column A1 entries
    > often.
    >
    > Thanks in advance
    >
    > Harry
    >
    >




+ 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