I have a sheet a sheet which records/calculates achieved Foreign Exchange rates.
There are 3 columns - € Rate; £ Used and € Got. The second two columns are given values according to the activity and the rate is a calculated cell by diving the £ Used by the € Got in each case.
The issue is that I am looking to calculate the highest (best) rate obtained and then attempting to highlight the (any) cells which meet that value.
In the Conditional Format, I am using the cell range and selecting
Is equal to and the cell which contains the highest rate, but this instruction appears to be ignored, and nothing is highlighted.
Is this because values in calculated cells are ignored for Conditional formatting rules purposes, and if so, what workaround or different mechanism is available to achieve highlighting the highest rate?
=B4=$E$2 works (where E2 contains the best rate and B4 is the first cell across the selected range) and if set as a custom formula, the correct action takes place.