+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, Conditional formatting help needed in Technical; Iíve been trying to use conditional formatting on an Excel spreadsheet and I need help! The spreadsheet has 5 columns. ...
  1. #1
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,133
    Thank Post
    177
    Thanked 49 Times in 42 Posts
    Rep Power
    24

    Conditional formatting help needed

    Iíve been trying to use conditional formatting on an Excel spreadsheet and I need help!

    The spreadsheet has 5 columns. Surname, Forename, Reg, DOB, Permission and I want to highlight the rows depending on the value in the permission cell. So if the permission cell = YES I want the whole row to be highlighted green and if the permission cell is NO I want the whole row to be highlighted red. Using conditional formatting I can get the permission cells to change colour but not the whole rows.

  2. #2
    AngryITGuy's Avatar
    Join Date
    Oct 2007
    Location
    County Durham
    Posts
    311
    Thank Post
    54
    Thanked 73 Times in 44 Posts
    Rep Power
    30
    Rather than basing your conditions on a cell value, you have to base the condition on a formula instead.

    Have used this many a time before and its straightforward enough, instructions for you here

  3. Thanks to AngryITGuy from:

    Jobos (3rd June 2008)

  4. #3
    sdc
    sdc is offline
    sdc's Avatar
    Join Date
    Apr 2008
    Location
    Dorset, UK
    Posts
    310
    Thank Post
    53
    Thanked 42 Times in 37 Posts
    Rep Power
    41
    Hi
    I've done this as a demo spreadsheet for you to try: download it here.

    Stephen

  5. Thanks to sdc from:

    Jobos (3rd June 2008)

  6. #4
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,133
    Thank Post
    177
    Thanked 49 Times in 42 Posts
    Rep Power
    24
    Quote Originally Posted by sdc View Post
    Hi
    I've done this as a demo spreadsheet for you to try: download it here.

    Stephen
    Thanks, that was spot on.

SHARE:
+ Post New Thread

Similar Threads

  1. Webpage formatting problem using Publisher
    By laserblazer in forum Web Development
    Replies: 8
    Last Post: 29th October 2007, 09:34 AM
  2. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 01:20 PM
  3. Replies: 5
    Last Post: 4th June 2007, 09:10 PM
  4. Formatting inside code block
    By ITWombat in forum Comments and Suggestions
    Replies: 4
    Last Post: 16th October 2006, 08:34 AM
  5. formatting w98
    By chrbb in forum Windows
    Replies: 6
    Last Post: 21st February 2006, 11:36 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
  •