Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
158
Views
Topic starter
Hi,
Would like to know if there is a way to format a cell based on numerical value and a text field.
I've attached the file which shows the format that i'd like to use based off a pivot table.
I'm trying to highlight cells values based on column headers and team as shown in cells H5:H9.
Apologies as I looked on google and on the forums but could not find what I needed.
Thanks in advance.
Posted : 07/07/2016 12:18 am
You have to add a conditional formatting rule, with the color you want, for range =$E$6:$G$9, with this formula:
=E$5=$H6
The $ sign is esential for the conditional formatting to work. More about conditional formattings: how-to-use-excel-conditional-formatting
Cheers,
Catalin
Posted : 07/07/2016 3:27 am
Topic starter
Thanks so much Catalin - much appreciated!
Posted : 07/07/2016 5:57 pm
