Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to change colors of cells based on value in cell (.
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 |
#2
|
|||
|
|||
Conditional formatting - see http://www.contextures.com/xlCondFormat01.html
-- HTH ------- Bob Phillips "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 |
#3
|
|||
|
|||
Hi LC
Highlight all cells you want to be affected by the condition Click on Format/Conditional Formatting Cell value between 0 and 255, set your formats, Click Add Cell value greater than 255, set your formats, Click Add Click OK HTH Michael "LC" wrote: 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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to change print ink color based on cell value? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |