| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell text color based on cell number
I have one column of 50 rows in which I put input Whole numbers. In cell A1
I may input 20. When I input that I may want the text color red or I may want it to be blue. How can I dictate what color is used with out having to change the color manually. I was working along the lines of if I enter 20 it is blue and If I enter 20.1 is red and format the cells so they dislay zero decimal points. I have not been able to figure this out. Help is Appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
| Changing a color in a cell based on the text in another cell | Excel Discussion (Misc queries) | |||
| Changing cell color based on cell value | Excel Programming | |||
| Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
Threaded Mode
