Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
Hello folks,
I am using the following formula to try and create some CF: ="minifs(aj4:aj63,aj4:aj63>0)"
I am trying to achieve highlighting the cell or cells that contain the lowest value that is greater than zero. What is wrong with my formula, please?
Mel
I am using the following formula to try and create some CF: ="minifs(aj4:aj63,aj4:aj63>0)"
I am trying to achieve highlighting the cell or cells that contain the lowest value that is greater than zero. What is wrong with my formula, please?
Mel