Ask Your Question
0

Problem with conditional formatting

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

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
0

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

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

Stats

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

Seen: 60 times

Last updated: Sep 07 '18