Notifications
Clear all
Topic starter
In the attachment I want to format the lowest number in each line
What formula do I put into a conditional design?
Posted : 23/02/2018 12:24 pm
Try this.
Hope this helps
Sunny
Posted : 23/02/2018 8:40 pm
Topic starter
Excellent works, thanks!
The MIN function understood
And I do not understand what action A2 = does
I would appreciate your explanation!
Posted : 24/02/2018 2:53 am
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
Posted : 24/02/2018 3:52 am
