| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing cell color
I need to either write a macro or a formula that will automatically change
the font of a cell if it is greater than the previous cell. For example, if a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing cell color
Hi Kas
You van use CF http://www.contextures.com/xlCondFormat01.html Select b1:Z1 ? And use this formula =A1<B1 Choose the format you want -- Regards Ron de Bruin http://www.rondebruin.nl "Kas" wrote in message ... I need to either write a macro or a formula that will automatically change the font of a cell if it is greater than the previous cell. For example, if a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing cell color
The help for "conditional formatting" will tell you how to do it.
Wolf "Kas" wrote: I need to either write a macro or a formula that will automatically change the font of a cell if it is greater than the previous cell. For example, if a1 = 3 and b1 = 4, I need 4 to be a different color. Can this be done? Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the color of a cell based on the color of another cell. | Excel Discussion (Misc queries) | |||
| Changing Cell Color | Excel Discussion (Misc queries) | |||
| Changing Cell Color | Excel Worksheet Functions | |||
| Changing cell color | Excel Programming | |||
| Changing a cell color.... | Excel Programming | |||
Linear Mode
