Ask Your Question

Problem with conditional formatting

asked 2018-09-07 10:08:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I keep weather records on a calc speadsheet. Each month has two columns one for the daily low temperature and one for the high. Within each column I have set conditonal formatting to highlight the lowest temperature of the month in blue and the highest in red. It has gone wrong and now highlights the lowest in blue but also highlights (apparenlty) random other entries in blue. If I try to alter the font in the rogue individual cells to black it doesn;t respond but remains blue. The formulae I use are A3=MIN(A$3:A$33) and A3=MAX(A$3:A$33)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-07 11:00:20 +0200

kompilainenn gravatar image

try make follow for your min temperature (delete all manual formatting from cells in ranges):

select your range and set this condition:

Cell value is - bottom 10 elements - 1, with blue color style for it

and for max temperature select your range and set this condition:

Cell value is - top 10 elements - 1, with red color style for it

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-07 10:08:27 +0200

Seen: 70 times

Last updated: Sep 07 '18