Excel Forum

Conditional Formatting

lea cohen

Member

Members

Forum Posts: 219

Member Since:
March 10, 2016

Offline

February 23, 2018 - 2:24 am

In the attachment I want to format the lowest number in each line
What formula do I put into a conditional design?

See Answer

SunnyKow

Puchong, Malaysia

VIP

Members

Trusted Members

Forum Posts: 1432

Member Since:
June 25, 2016

Offline

February 23, 2018 - 10:40 am

Try this.

Hope this helps

Sunny

lea cohen

Member

Members

Forum Posts: 219

Member Since:
March 10, 2016

Offline

February 23, 2018 - 4:53 pm

Excellent works, thanks!
The MIN function understood
And I do not understand what action A2 = does
I would appreciate your explanation!

SunnyKow

Puchong, Malaysia

VIP

Members

Trusted Members

Forum Posts: 1432

Member Since:
June 25, 2016

Offline

February 23, 2018 - 5:52 pm

The A2 formula is used to compare against the range in the same row to check if it is the minimum value.

If it is the minimum then format that cell.

The A2 formula is a relative reference and will adjust it self when applied to different cells.

Note that the MIN formula is column-absolute.

Hope this is clear.

Sunny

Answers Post

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: RAQUEL ACION, Dana Friedt, Shawn Barwick, Nada Perovic

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

terimeri dooriyan

Jack Aston

AndyC

Denise Lloyd

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Forum Stats:

Groups: 3

Forums: 24

Topics: 6218

Posts: 27266

Member Stats:

Guest Posters: 49

Members: 31901

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen