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
Bookmarks