+ Reply to Thread
Results 1 to 3 of 3

A macro to color the cells according to the values existing in a c

  1. #1
    Zancouth
    Guest

    A macro to color the cells according to the values existing in a c

    Hi,

    Does anyone know if it is possible to do a macro that would automatically
    color the rows RED( for example ) according to the values in a column ?

    E.g. at col B, when the value is IN , the entire row would be colored blue.
    when the value is OUT , the entire row would be colored red.




  2. #2
    Bob Phillips
    Guest

    Re: A macro to color the cells according to the values existing in a c

    Use conditional formatting

    See http://www.contextures.com/xlCondFormat01.html

    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    "Zancouth" <Zancouth@discussions.microsoft.com> wrote in message
    news:7D7A10F1-0E7B-4FEE-B69B-F4BB5D517E72@microsoft.com...
    > Hi,
    >
    > Does anyone know if it is possible to do a macro that would automatically
    > color the rows RED( for example ) according to the values in a column ?
    >
    > E.g. at col B, when the value is IN , the entire row would be colored

    blue.
    > when the value is OUT , the entire row would be colored red.
    >
    >
    >




  3. #3
    FSt1
    Guest

    RE: A macro to color the cells according to the values existing in a c

    hi,
    yes it is possible but based on your post, conditional formating might be a
    better option.
    in column B put the following 2 coditions
    condition1...if cell value is = "in" set format to blue
    condition2...if cell value is = "out" set format to red.
    in all the other cell in the rows put the following 2 conditions
    condition1...formula is =IF($B2="in",1,0) set format to blue
    condition2...formula is =IF($B2="out",1,0) set format to red.

    hope this helps
    regards
    FSt1

    "Zancouth" wrote:

    > Hi,
    >
    > Does anyone know if it is possible to do a macro that would automatically
    > color the rows RED( for example ) according to the values in a column ?
    >
    > E.g. at col B, when the value is IN , the entire row would be colored blue.
    > when the value is OUT , the entire row would be colored red.
    >
    >
    >


+ 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