changing colour cell and text by clicking cell

  • Thread starter Thread starter hannes
  • Start date Start date
H

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
 
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
Click to expand...

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?
 
"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
Click to expand...
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?
Click to expand...

I want it to occur always when i click one off the cells (O22::X44) even if
the cell is empty.
 
Back
Top