In the past an expert called Dave helped me with a formula to assess excel numbers based on certain conditions, he is probably asleep so I wonder if another expert could assist me with this request.
I'm looking to sort data based on the following, (as illustrated in the attached spreadsheet)
On the 20th day I would like establish if the low cell CB2 (93.4) was the lowest price for past twenty days - I think this can be achieved with =MIN(C2:CC2), but you're the experts - True/False
Is CD > CA True/False
Is CH > CE & CH > CD - True/False
Is CL > CI & CL > CH - True/False
If all four conditions are true or false I would like the result shown in column CR.
Finally, I would like a conditional format in cell A2 which will be highlighted if any of the results in column CR are true.
I've tried to explain myself as best I can. However, if you need further clarification to help me with my request, please let me know