Today I've tried adding conditional formatting to my spreadsheet. Basically what I've tried to achieve is not highlight maximum value in the column. It simply does not work - after entering formula and applying the formatting all the values below the one that should get a highlight were highlighted. Tried moving the data to new spreadsheet, removing formulas and using only values etc. Nothing helped. At this point IMO conditional formatting in 7.0.3 is unusable, sadly. Hope someone will be able to nail it down. Here's the video showing the issue: https://vimeo.com/507490738
You did not use absolute addressing in your formula. You need to use =MAX(M$2:M$13)
ok, cool - thx. Obvious mistake - but maybe some sort of check and warning in the window would be a good enhancement idea?
(In reply to Przemek from comment #2) > ok, cool - thx. Obvious mistake - but maybe some sort of check and warning > in the window would be a good enhancement idea? Hmm... How should the application know what you want? The formula you have used is not wrong and there may be uses case where you exactly want what you have used.