| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
changing colour cell and text by clicking cell
Hi.
In a worksheet i have in cells O22::X44 numbers from 1 to 9. Now i what that when i click one of these cells that the cell colour changes to red and the text changes to white Is this possible? Hannes |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
changing colour cell and text by clicking cell
On Mar 16, 5:41*am, "hannes" wrote:
Hi. In a worksheet i have in cells O22::X44 numbers from 1 to 9. *Now i what that when i click one of these cells that the cell colour changes to red and the text changes to white Is this possible? Hannes It is possible but when do you want that to occur? When the number is 1? When the number is 2? When the number in the cell is anything from 1 to 9 inclusive? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
changing colour cell and text by clicking cell
"trip_to_tokyo" schreef in bericht ... On Mar 16, 5:41 am, "hannes" wrote: Hi. In a worksheet i have in cells O22::X44 numbers from 1 to 9. Now i what that when i click one of these cells that the cell colour changes to red and the text changes to white Is this possible? Hannes It is possible but when do you want that to occur? When the number is 1? When the number is 2? When the number in the cell is anything from 1 to 9 inclusive? I want it to occur always when i click one off the cells (O22::X44) even if the cell is empty. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell color by clicking the cell | Excel Programming | |||
| Colour by clicking cell | New Users to Excel | |||
| how to change cell colour by simply clicking on it | Excel Discussion (Misc queries) | |||
| Changing row colour if text string present in a cell? | Excel Programming | |||
| Changing colour of text in cell | Excel Programming | |||
Linear Mode
