Fantastic! I knew it had to be something simple.. If I have more conditions,
do you have any ideas?

Also, I know this odd but is there a way of doing this in reverse?... i.e.
if it is green insert a "b"?

J

"bpeltzer" wrote:

Assuming you have three or fewer conditions, then conditional formatting can
handle this. In A20, for example, set the first CF to read 'formula is'
=$I20="B".
You can fill this across and down. Additional conditions can be applied
just like normal.

"James M" wrote:

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