+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, Excel Cell colour changes in Technical; Okay I know I can use conditional formatting on a cell depending on the value within that cell however I ...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Excel Cell colour changes

    Okay I know I can use conditional formatting on a cell depending on the value within that cell however I want to change its colour depending on the value of an adjacent cell and seeing as Excel is not my forte I wondered if anyone there would know?

    Wes

  2. #2

    Join Date
    Jan 2006
    Posts
    143
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Excel Cell colour changes

    Instead of applying the formatting based on the cell's own value, base on the formula of your choice.

  3. #3
    alonebfg's Avatar
    Join Date
    Aug 2006
    Location
    south west some of the time
    Posts
    834
    Thank Post
    12
    Thanked 34 Times in 21 Posts
    Blog Entries
    5
    Rep Power
    24

    Re: Excel Cell colour changes

    or you can write a visual basic formula i did used to know how to do it but it has been a while will look in the old books if you like

  4. #4

    Join Date
    Oct 2005
    Location
    Lancashire
    Posts
    110
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Excel Cell colour changes

    There is probably an easier way but, if I can't see an obvious function, I tend to use a bit of VBA.

    The following subroutine checks if A2 is greater than 1. If it is then it changes the colour of A1 to red

    Sub change_colour
    If cells(1,2).value>1 then
    Range("A1").Select
    Selection.Interior.ColorIndex=3
    End If
    End Sub

    Attach it to a macro button or key press. If you have a lot of data a for/next loop can easily be added.

SHARE:
+ Post New Thread

Similar Threads

  1. A3 colour lasers
    By Oops_my_bad in forum Hardware
    Replies: 11
    Last Post: 12th September 2007, 09:08 AM
  2. Colour Printing.. what is better ?
    By Grommit in forum Windows
    Replies: 23
    Last Post: 23rd February 2007, 12:40 AM
  3. Colour Laser - any ideas?
    By kiran in forum Hardware
    Replies: 20
    Last Post: 11th December 2006, 12:07 AM
  4. Colour of the start/task bar
    By eastlondon in forum Windows
    Replies: 11
    Last Post: 1st August 2006, 02:11 PM
  5. Reccomend me some colour Lasers pls
    By ChrisH in forum Hardware
    Replies: 29
    Last Post: 27th September 2005, 11:11 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •