Conditional Formatting, telling the difference between and A and A* grade

[EmmaN]

Hi,

When using conditional formatting in cells, if im showing an A grade and an A* grade I want them to show as different colours. I can't get conditional formatting to show them as different. Im sure its something really simple im not doing but my brain is fried today and i cant work it out. Any suggestions gratefully appreciated. Thank you. Emma

 

[jtakw]

Hi,

You can just use a different formula for each CF condition, in my sample below, I'm using A1:A4, but that's just to show you the formulas, you would use A1 in all the conditions; however, I believe the limit is 3 conditions not including the original Cell formatting (so total of 4 if you include Cell formatting).

Book1
	A	B
1	A	TRUE
2	A*	TRUE
3	A+	TRUE
4	A-	TRUE
Sheet2

Cell Formulas
Range	Formula
B1	=A1="A"
B2	=A2="A*"
B3	=A3="A+"
B4	=A4="A-"

 

[Peter_SSs]

Hi,

When using conditional formatting in cells, if im showing an A grade and an A* grade I want them to show as different colours. I can't get conditional formatting to show them as different. Im sure its something really simple im not doing but my brain is fried today and i cant work it out. Any suggestions gratefully appreciated. Thank you. Emma

Hard to know what is going wrong without seeing some sample data and exactly what Conditional Formatting rule(s) you have tried. Here's mine:

Excel Workbook
	A
1	A
2	A-
3	A*
CF EmmaN

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A1="A"	Abc
A1	2. / Formula is =A1="A*"	Abc