+ Reply to Thread
Results 1 to 4 of 4

help fill color formula/macro

  1. #1
    Registered User
    Join Date
    02-03-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Question help fill color formula/macro

    Good afternoon,

    I'm new on this forum (and quite a newbe of excel), I've searched but didn't found any solution yet for my problem which is:

    I want to fill my rows/line of a particular color regarding the result of a cell for each line. for example:

    If A1 is = 1, then A1 B1 C1 D1 D1 will be all in RED / If A1 is = 2, then A1 B1 C1 D1 D1 will be all in GREEN
    If A2 is = 1, then A2 B2 C2 D2 D2 will be all in RED / If A2 is = 2, then A2 B2 C2 D2 D2 will be all in GREEN
    If a3 is =1 then A3 ....... etc

    I can make it for one row using the conditional formatting but this is for one ligne only and I need it for approx. 100 row.
    is there any formula like:
    =IF(A1=1, A1:D1 COLOUR FULL RED,0)

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: help fill color formula/macro

    try this in conditional formatting.
    1) new rule
    2) use a formula to determine which cells to format
    3) enter formula of ($A1=1)
    4) click format button, go to fill tab, pick color you want
    5) click ok then ok, then apply, next open conditional formatting again and add new rule
    repeat for ($A1=2) and pick the green.
    then using format painter go over the columns B through D and they should be formatted to change if the cell in colA is 1 or 2.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,256

    Re: help fill color formula/macro

    Some thing like this?
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    02-03-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: help fill color formula/macro

    heyyy guys yeaaa exactly Popipipo i know how to do it now really thanks a lot guys !!! u rock

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  2. [SOLVED] Random fill color macro
    By korndorb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2013, 07:25 PM
  3. [SOLVED]Fill Color (highlight cells) but not to print fill color
    By itszille in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-24-2012, 05:37 PM
  4. Macro to fill the color in particular cell
    By judethomas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2012, 04:28 AM
  5. Macro to change the Fill-Color command color
    By Ingeniero1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 01:40 PM

Tags for this Thread

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