Forum Discussion
Solved
Conditional Formatting based on comparing cell references
Hi All, I have a rate spread sheet (below) that has 7 columns: A B C D E F G 1 Cost Descr Cost Amount Rate Applied Rate Factor Current Rate (light green) Live Rate (lig...
OK, try this.
alex_n , here you go!
Best
Ricardo, thanks for trying. But your solution is based on the value and not the actual cell reference. The reason behind me wanting it based on the cell reference is because sometimes the rates can be identical (ex. Current rate can be identical to the Historical rate) and it may cause bug in the result. Thanks.