View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
november678x
 
Posts: n/a
Default Conditional Formatting With Grades


Hello to all,

I am trying to get conditional formatting to do the following with
grades:

If grades are A+, A, A-, B+, B format background to Green

If grades are B-, C+, format background to Yellow

If grades are C, C-, D+, D, D-, F format background to Red


Any help would be appreciated, Thank you :)


--
november678x
------------------------------------------------------------------------
november678x's Profile: http://www.excelforum.com/member.php...o&userid=23641
View this thread: http://www.excelforum.com/showthread...hreadid=548704