Hi all:

I have a grid displaying 8 columns. I would like to achieve the following:

- columns 2-8 should display background color (say blue)
- if the text in any of the 2-8 columns is = "*BLOCK*", then, that cell in the grid should have a backcolor of (say red), else, the backcolor should be (say yellow)

Any suggestions would be appreciated. TIA

- Ravi