Hi
Hopefully you can help
I have a spreadsheet with grades in one column and grades in the second column
I want to first column to change if the grade is lower than the adjacent cell.
My grades are A1,A2,A3,B1,B2,B3 etc down to U and the same with the other column.
So if in column 1 a cell = B3, but in column 2 it is B2 or higher I want the cell in column 1 to go red
Can you help?
Thanks in advance much appreciated.
Here's one way: using a named range for a complete list of your grades (you'll have to complete the list in DESCENDING order), but the Named range will extend ayutomatically to cover the additions)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks so much - works like a dream and my boss is pleased!
thanks for the quick response
Ha Ha. If you AND the Boss are pleased, i guess that that counts as a result!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Hi
Can I just ask - is there anything i can add so that cells that are blank do not go red.
You have me baffled. On the sheet that is attached here, the conditional formatting applies from cells A1 to A50. Only the two cells that should be red, are red. Can you post an example showing the problem?
Sorry
Clearly my fault - bit of a rookie mistake.
You can rest easy - apologies for any unnecessary confusion caused!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks