Results 1 to 2 of 2

Excel 2007 : Comparing Columns and conditional formatting

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    coventry, england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Comparing Columns and conditional formatting

    Hi

    I need some help.....my knowledge on excel is not very great.

    I have a list of students with their school target grades (A, B ,C D E ..) in one column.
    In the next column I have their current performance grades (A B C D E ..)

    If their current performance grades are below their school target grade then the students name in column A should get highlighted (eg, Target grade B, performance grade C, then students name should highlight in red say).

    Is there any way to do this???

    Any help will be really appreciated.
    Last edited by SAJ; 09-13-2011 at 04:04 PM.

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