Hi

so if the cell value was 0 you want black, if it was 128 you want a mid-grey
and if it was 255 you want white - with all graduations between?

if this is so, i don't think excel will show the graduations as distinct as
you wish, but you could try the following code:

Private Sub Worksheet_Change(ByVal Target As Range)

Dim gcolour As Long

If Target.Address = "$K$4" And Target.Value < "" Then
gcolour = Target.Value
Target.Interior.Color = RGB(gcolour, gcolour, gcolour)
End If
End Sub

---
to use the code, right mouse click on the sheet tab of the sheet you want
the code to work in, choose view code and paste this code on the right hand
side of the screen.
change the K4 to the cell you're interested in formatting.

Cheers
JulieD

"LC" wrote in message
...
I would like to have the background of cell automatically shaded in grey
level based on the value contained in the cell (values between 0-255).
0 would correspond to Black
255 to white