+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, Conditional formatting help needed in Technical; ...
  1. #1
    Jobos's Avatar
    Join Date
    Apr 2007
    Posts
    1,165
    Thank Post
    186
    Thanked 55 Times in 47 Posts
    Rep Power
    26

    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
    314
    Thank Post
    55
    Thanked 73 Times in 44 Posts
    Rep Power
    31
    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
    312
    Thank Post
    53
    Thanked 42 Times in 37 Posts
    Rep Power
    42
    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,165
    Thank Post
    186
    Thanked 55 Times in 47 Posts
    Rep Power
    26
    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, 10:34 AM
  2. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 02:20 PM
  3. Replies: 5
    Last Post: 4th June 2007, 10:10 PM
  4. Formatting inside code block
    By ITWombat in forum Comments and Suggestions
    Replies: 4
    Last Post: 16th October 2006, 09:34 AM
  5. formatting w98
    By chrbb in forum Windows
    Replies: 6
    Last Post: 21st February 2006, 12:36 PM

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
  •