Forum Discussion
Win Rate Percentage Conditional Formatting
Thanks! Since column F contains a percentage, the conditional rules should use percentages too. Instead of coloring a cell green if its value is greater than 50, you should color it if its value is greater than 50%.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans,
I am attaching the link to my template file on Google Drive. I have entered some generic data to demonstrate what is happening. The file is for tracking my options trading and tracking wins/losses and win percentage, etc.
The "Annual Total" tab is where I am having issues. Column F is where the fill is not correcting as the "Win Percentage" number changes from the data entered in "Week 1", "Week 2", etc. tabs.
https://drive.google.com/drive/folders/1qiPv-QLFU8Z1swM-DQrQzTZocqSTCNDJ?usp=share_link
Take a look and let me know what you think.
Thanks again for your help.
Kent
Thanks! Since column F contains a percentage, the conditional rules should use percentages too. Instead of coloring a cell green if its value is greater than 50, you should color it if its value is greater than 50%.
- Oh my gosh, I swear I tried that but apparently not. Thank you so much. Simple fix and it is working perfect now.
Cheers,
Kent