ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   changing colour cell and text by clicking cell (https://www.excelbanter.com/new-users-excel/445504-changing-colour-cell-text-clicking-cell.html)

hannes

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



trip_to_tokyo[_3_]

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?

hannes

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.




All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com