Current Row Reference

[wendyglasgow]

Hi,

I am trying to reference a colum in the current row in conditional formatting in a workbook.

I know that I can do conditional formatting, but I don't want to have to do it for each line.

Basically I want to say:

If the value of the cell in currentRow column A > currentRow column D then format currentRow column F however.

I'm sure it's probably really simple, but the only way I can get it to work is if I do a seperate conditional formatting for every row in my spreadsheet.

I know ther must be a way to refer to a current row eg $A$currentRow but I can not seem to find it anywhere at all.

If you could please help I would really appreaite it.

Thanks,
Wendy Glasgow