changing colour cell and text by clicking cell

[hannes]

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]

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]

"trip_to_tokyo" <[email protected]> schreef in bericht

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.