Hi Robert,
Works like a treat. Thank you so much!
It is weird there is no simpler (shorter formula or standard function) and less work intensive (changing every row) way. It seems like an often needed tool ... okay, only needed it once, but I use spreadsheet analysis only once or twice a year
Search found 4 matches
- Wed Jun 12, 2019 2:10 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 6723
- Tue Jun 04, 2019 7:26 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 6723
Re: conditional formatting - highest and 2nd highest
Hi Robert,
I have copied and pasted your formula, but Planmaker complains 'One of the values/fomulas is invalid or missing'. Any ideas?
I have copied and pasted your formula, but Planmaker complains 'One of the values/fomulas is invalid or missing'. Any ideas?
- Mon Jun 03, 2019 3:06 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 6723
Re: conditional formatting - highest and 2nd highest
Hi Robert,
Shame this simple task is problematic for Planmaker or Excel. Looking forward to your suggestions once you had a closer look.
Shame this simple task is problematic for Planmaker or Excel. Looking forward to your suggestions once you had a closer look.
- Sat Jun 01, 2019 8:11 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 6723
conditional formatting - highest and 2nd highest
Hi all, I have a table with 10 columns and 24 rows. I have tried to use the conditional formatting to highlight the highest and second highest value per column with a colour each. I used 'use formula to determine which cells to format' plus the formulas =C2=MAX($C$2:$L$2) and =C2=LARGE($C$2:$L$2,2) ...