Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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