I am trying to figure out how to format an entire column of cells (108 entries in total) so that each particular cell will become highlighted if data exists in a corresponding cell on another worksheet. I have figured out how to do it in on a cell by cell basis, but can't seem to figure out how to do all 108 cells at once. If I try to conditionally format them all, then the entire column becomes highlighted.

Example:

I want a cell to become highlighted if data is entered on in another cell on another worksheet.

The current formula I am using on cell D2 on the main worksheet is:

='SoA & Disbursements'!$F$2>0

Therefore, if a value exists in cell F2 on the corresponding worksheet, this cell becomes highlighted. This seems to work no problem. Can I expand this formula to encompass the 108 cells in column D (D2:D109) so that each cell points to a particular cell in column F (F2:F109), or do i have to manually enter this formula into all 108 cells?

Thanks for any input.