I am looking for some help in applying a conditional format to a number of cells in a number of different rows.
The criteria is as follows;
If the current cell value is greater than 0,
the value of the cell in the same row, but column C is greater than $A$1
I have tried a number of things but it keeps reverting either to a text line in the condition, or giving an error.
I am at home at the moment, and do not have Excel on this laptop.
I will check in again from work tomorrow.
Thanks in advance.