Eric Carolus
Board Regular
- Joined
- Sep 17, 2012
- Messages
- 131
- Office Version
- 2016
- Platform
- Windows
Hi folks
I have two adjacent columns Tickets and Amount.
If the cell in column Tickects (has a ticket number) has a number, then the corresponding cell in Amount has a RED background fill. [my code for this works]
If the cell in column Tickects (has a ticket number) has a number, then the corresponding cell in Amount shows the number 80 (price of ticket) and has a GREEN background fill. [my code for this works]
My problem is as follows: If I remove/clear the ticket number from the Ticket column, the the corresponding cell in the Amount column (a) the fill must become no fill (if the cell fill was RED
(b). The fill must become no fill (if the cell fill was GREEN and the 80 must be removed/cleared from the cell.
Please look at the code on module 1
Any help will be appreciated
Crow
I have two adjacent columns Tickets and Amount.
If the cell in column Tickects (has a ticket number) has a number, then the corresponding cell in Amount has a RED background fill. [my code for this works]
If the cell in column Tickects (has a ticket number) has a number, then the corresponding cell in Amount shows the number 80 (price of ticket) and has a GREEN background fill. [my code for this works]
My problem is as follows: If I remove/clear the ticket number from the Ticket column, the the corresponding cell in the Amount column (a) the fill must become no fill (if the cell fill was RED
(b). The fill must become no fill (if the cell fill was GREEN and the 80 must be removed/cleared from the cell.
Please look at the code on module 1
Any help will be appreciated
Crow
Chicken Braai _Saal_Kommitee_Nov.xlsm | |||
---|---|---|---|
E | |||
24 | |||
Horn Fam |