Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I've been draining my brain trying to work out how I can do this. I'm using data validation with a list/dropdown box with J, K and L options. The current colours are in sheet 'Training Log' L2:L4. The column is formatted as Wingdings so the cell in Col H shows either a happy, neither happy or sad, or unhappy smiley. The conditional formatting fills the cell Green for J, Gold for K and Red for L as below.
What I want to do is use the happy smiley (wingdings J) again with the letter R and yellow fill and I'm stuck, as conditional formatting relies on what's in the cell and the happy smiley can only be with the letter J.
I presume this can be done but with code instead? The cell being filled is Col H in the last filled row.
Help appreciated - many thanks!
I've been draining my brain trying to work out how I can do this. I'm using data validation with a list/dropdown box with J, K and L options. The current colours are in sheet 'Training Log' L2:L4. The column is formatted as Wingdings so the cell in Col H shows either a happy, neither happy or sad, or unhappy smiley. The conditional formatting fills the cell Green for J, Gold for K and Red for L as below.
Validation Col.H |
J |
K |
L |
What I want to do is use the happy smiley (wingdings J) again with the letter R and yellow fill and I'm stuck, as conditional formatting relies on what's in the cell and the happy smiley can only be with the letter J.
I presume this can be done but with code instead? The cell being filled is Col H in the last filled row.
Help appreciated - many thanks!
Last edited: