How to set Excel Conditional Formatting based on it's own range
Hi,
How can I set conditional formatting in excel to highlight a cell based on the value max/min of within it's own range? (I have included an excel that does this but I had to include additional formulas outside the conditional formatting in order to get the effect I want. I'm trying to get the same effect but only using conditional formatting.
ConditionalFormattingMAXMIN.xlsx
How can I set conditional formatting in excel to highlight a cell based on the value max/min of within it's own range? (I have included an excel that does this but I had to include additional formulas outside the conditional formatting in order to get the effect I want. I'm trying to get the same effect but only using conditional formatting.
ConditionalFormattingMAXMIN.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER