A2:J2 is just one row, not many.

But you can use the format painter, the paintbrush icon on the toolbar, and
copy the format of A2:J2 and paint it onto other rows.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Cindy" wrote in message
...
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!!