Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the color of cell background based on a result
I would like to have the result of my function to change the color of the
cell in which the result is displayed. For example: 1- if the value of cell A1 is less than or equal to the value of cell C2 then display the difference between cells C2 and A1 in cell D4 with a "green" background. or 2- if the value of cell A1 is greater than the value of cell C2 then display the difference between cells C2 and A1 in cell D4 with a "red" background. I can get the "IF" function to display the numeric value I want, but cannot get the background shading to change with the perameters I specified above. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change background color based on value in column A | Excel Discussion (Misc queries) | |||
Auto change background of color based on formula | Excel Worksheet Functions | |||
Changing background color based on different cell | Excel Discussion (Misc queries) | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) |