Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I currently have this setup:
My formulas in columns J-M look at their respective counterparts in columns D-G and once all four numbers have been entered in columns D, E, F and G, the cells in columns J-M will highlight which one has the lowest value. However, I would like to highlight this further and have some conditional formatting that also highlights the cell that returns the value for whichever cell has the lowest value. So in the first case column G contains the lowest value (first row of my IF(AND) formula) and I would like for this cell containing "KOLONNE G" to be highlighted with a red color.
My issue is that I am terribly bad at conditional formatting and I have no idea how to do this. Can somebody please help me? Would be greatly appreciated!
Thank you all
Kind regards,
Jyggalag
I currently have this setup:
My formulas in columns J-M look at their respective counterparts in columns D-G and once all four numbers have been entered in columns D, E, F and G, the cells in columns J-M will highlight which one has the lowest value. However, I would like to highlight this further and have some conditional formatting that also highlights the cell that returns the value for whichever cell has the lowest value. So in the first case column G contains the lowest value (first row of my IF(AND) formula) and I would like for this cell containing "KOLONNE G" to be highlighted with a red color.
My issue is that I am terribly bad at conditional formatting and I have no idea how to do this. Can somebody please help me? Would be greatly appreciated!
Thank you all
Kind regards,
Jyggalag