Thread: changing colour cell and text by clicking cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
  
Posts: 833
Default 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?
Reply With QuoteReply With Quote