Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto enable Excel, set cell color based on the numerical va
I am creating a spreadsheet and would like to be able to choose the color of
what the text or number will look like depending on certain variables which would be entered into a cell. example: if the value determined by the =sum function is less then 0. (In other words a negative value) I would like for the cell to be able to change the negative number to red. If the value determined by the =sum function is then 0 then the color of the number would be green. If the value equaled to 0 then blue or black. Also I would like to do something similar to the above example. Although I would like the color of the number entered into a cell to show a color depending on a value specified in an ABSOLUTE REFERENCE cell. Example such as, the ABSOLUTE REFERENCE cell could be $D$3 which references a value of 9. So if the numerical value entered into another cell, such as B3 and the entered value is less then 9 I would like for the number to be displayed in RED. If the value is equal to 9 then black. If the value is then 9 then GREEN. Finally one other thing. I would like to be able to automatically add FILL SHADING to cells based upon values having some of the same criteria as the above examples. Hopefully I have explained myself clearly enough for you to be able to help me in determining examples of how to set these automatic capabilites up within excel. Thanks in Advance, Robert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto enable Excel, set cell color based on the numerical va
Hi,
Have a look at conditional formatting in help, it does exactly what you want. Mike "HydroRamPac" wrote: I am creating a spreadsheet and would like to be able to choose the color of what the text or number will look like depending on certain variables which would be entered into a cell. example: if the value determined by the =sum function is less then 0. (In other words a negative value) I would like for the cell to be able to change the negative number to red. If the value determined by the =sum function is then 0 then the color of the number would be green. If the value equaled to 0 then blue or black. Also I would like to do something similar to the above example. Although I would like the color of the number entered into a cell to show a color depending on a value specified in an ABSOLUTE REFERENCE cell. Example such as, the ABSOLUTE REFERENCE cell could be $D$3 which references a value of 9. So if the numerical value entered into another cell, such as B3 and the entered value is less then 9 I would like for the number to be displayed in RED. If the value is equal to 9 then black. If the value is then 9 then GREEN. Finally one other thing. I would like to be able to automatically add FILL SHADING to cells based upon values having some of the same criteria as the above examples. Hopefully I have explained myself clearly enough for you to be able to help me in determining examples of how to set these automatic capabilites up within excel. Thanks in Advance, Robert |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto enable Excel, set cell color based on the numerica
Hi Mike,
Thanks for the update, I will look into the conditional formating. Robert "Mike H" wrote: Hi, Have a look at conditional formatting in help, it does exactly what you want. Mike "HydroRamPac" wrote: I am creating a spreadsheet and would like to be able to choose the color of what the text or number will look like depending on certain variables which would be entered into a cell. example: if the value determined by the =sum function is less then 0. (In other words a negative value) I would like for the cell to be able to change the negative number to red. If the value determined by the =sum function is then 0 then the color of the number would be green. If the value equaled to 0 then blue or black. Also I would like to do something similar to the above example. Although I would like the color of the number entered into a cell to show a color depending on a value specified in an ABSOLUTE REFERENCE cell. Example such as, the ABSOLUTE REFERENCE cell could be $D$3 which references a value of 9. So if the numerical value entered into another cell, such as B3 and the entered value is less then 9 I would like for the number to be displayed in RED. If the value is equal to 9 then black. If the value is then 9 then GREEN. Finally one other thing. I would like to be able to automatically add FILL SHADING to cells based upon values having some of the same criteria as the above examples. Hopefully I have explained myself clearly enough for you to be able to help me in determining examples of how to set these automatic capabilites up within excel. Thanks in Advance, Robert |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto enable Excel, set cell color based on the numerica
Conditional formating is sweet. It saves a lot of time.
Thanks again, Robert "Mike H" wrote: Hi, Have a look at conditional formatting in help, it does exactly what you want. Mike "HydroRamPac" wrote: I am creating a spreadsheet and would like to be able to choose the color of what the text or number will look like depending on certain variables which would be entered into a cell. example: if the value determined by the =sum function is less then 0. (In other words a negative value) I would like for the cell to be able to change the negative number to red. If the value determined by the =sum function is then 0 then the color of the number would be green. If the value equaled to 0 then blue or black. Also I would like to do something similar to the above example. Although I would like the color of the number entered into a cell to show a color depending on a value specified in an ABSOLUTE REFERENCE cell. Example such as, the ABSOLUTE REFERENCE cell could be $D$3 which references a value of 9. So if the numerical value entered into another cell, such as B3 and the entered value is less then 9 I would like for the number to be displayed in RED. If the value is equal to 9 then black. If the value is then 9 then GREEN. Finally one other thing. I would like to be able to automatically add FILL SHADING to cells based upon values having some of the same criteria as the above examples. Hopefully I have explained myself clearly enough for you to be able to help me in determining examples of how to set these automatic capabilites up within excel. Thanks in Advance, Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How I auto fill a cell patern or color based on a pick list? | Excel Discussion (Misc queries) | |||
enable/disable button based on cell value | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Auto change background of color based on formula | Excel Worksheet Functions | |||
Cell Background Color Change according to numerical value | Excel Discussion (Misc queries) |