|
North of London | I have done this before but have hit a blank the last couple days.
I have spreadsheets with weather records on then by month.
Each month sheet has been set up to highlight the highest temp and biggest rainfall amount in red and lowest in blue.
I have never set that up on my October sheet and have tried several times in the past couple days to figure it out but am failing to find the correct solution.
To explain it more a column has rainfall amount for 37 years recorded and I want it to highlight the highest and lowest years amounts
Can do it manually but so much easier and less chance of missing the correct number when Excel highlights it for me.
Thanks for walking an old man through something I have figured out before
| |
|
Excel help
