have a look at
formatconditional formatting
very self explanatory

--
Don Guillett
SalesAid Software

"GRobertson" wrote in message
...
Hi,

I have a spreadsheet with a list of cases in rows. Coloumn D lieterally
has
a letter B or R, basically I would like some code that if coloumn D says R
then that row is displayed in red if coloumn D says B then the row is
displayed in blue.

Is this possible
Many Thanks
Glenn Robertson