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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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,897
Messages
6,175,270
Members
452,628
Latest member
dd2

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