Is there a way of highlighting cells lower or higher containing text and numbers.

Davebro

Board Regular
Joined
Feb 22, 2018
Messages
135
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
Is there anyway of highlighting cells lower or higher. Green for lower and red for higher. I am using a pivot table where A1 changes.
I could just delete the word class, in each of the columns I suppose, but this is extra work and does not look as good.

Class 4
AClass 1
BClass 2
CClass 3
DClass 4
EClass 5
FClass 6
GClass 4`
HClass 2
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
you could use this in conditional formatting

will there be a ' in the text as in G
also will the class be more than 1 number

are you still using 2016 excel

showing the formula

Book7
ABCDE
1Class 4
2
3AClass 1TRUE
4BClass 2TRUE
5CClass 3TRUE
6DClass 4FALSE
7EClass 5FALSE
8FClass 6FALSE
9GClass 4FALSE
10HClass 2TRUE
Sheet1
Cell Formulas
RangeFormula
E3:E10E3=(RIGHT(C3,1)*1)<RIGHT($A$1,1)*1


with conditional formatting
Book7
ABC
1Class 4
2
3AClass 1
4BClass 2
5CClass 3
6DClass 4
7EClass 5
8FClass 6
9GClass 4
10HClass 2
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C3:C10Expression=(RIGHT(C3,1)*1)>RIGHT($A$1,1)*1textNO
C3:C10Expression=(RIGHT(C3,1)*1)<RIGHT($A$1,1)*1textNO
 
Upvote 1
Solution
Hello, many thanks for your solution, I am still using 2016 version. This works fine, thank you so much for your help.
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top