I have a reasonably large spreadsheet (about 2000 rows) and i need to format
each row based on the value of a cell in a specific column.

For example, if there is a "B" in Cell I20, I need to fill the whole of Row
20 with the colour green. I then need to apply this to every row.

Similarly if there is a different letter, I need to make the row a different
colour...

All help gratefully appreciated!

J