Forum

Notifications
Clear all

Conditional formatting using named range

4 Posts
2 Users
0 Reactions
38 Views
(@nicka)
Posts: 2
New Member
Topic starter
 

This question was triggered by the youtube video here:

SOLVED - Stop Conditional Formatting Duplicating & Fragmenting

I am trying to apply the logic to an excel table that has 5 columns, and the first column is sorted in ascending order.

The conditional formatting formula should draw a border line when the value of the first column changes. Sample image follows.

image

I tried to attach an excel file with my attempts but I get filetype not allowed error message.

 

 
Posted : 23/08/2025 5:33 am
Alan Sidman
(@alansidman)
Posts: 238
Member Moderator
 

What file type are you  trying to attach?

 
Posted : 23/08/2025 8:43 am
(@nicka)
Posts: 2
New Member
Topic starter
 

.xlsx and I also tried .zip

 
Posted : 23/08/2025 9:10 am
Alan Sidman
(@alansidman)
Posts: 238
Member Moderator
 

Did you read this when you signed up to participate in this forum?  If not, suggest you do so now.

https://www.myonlinetraininghub.com/excel-forum/forum-rules-and-guides/read-this-first

This post was modified 2 hours ago by Alan Sidman
 
Posted : 23/08/2025 11:32 am
Share: