Rows A2:J2 comrpise only one row, row 2. So your conditional formatting is
working as it should.

Do you mean columns A:J?

Dave
--
Brevity is the soul of wit.


"Cindy" wrote:

This is my current spreadsheet:
Rows: A2 - J2
Conditional Formating
1) =$F2="Y" (format Green)
2) =$F2="N" (format Red) and this works for Row 2

What I need is to have this same format work on each row and I just cannot
get it to work! Please HELP!!