Forum Discussion
Win Rate Percentage Conditional Formatting
Hello,
I am trying to use conditional formatting for a win rate percentage column as follows:
win rate less than or equal to 50 then fill cell red
win rate is greater than 50 then fill cell green
I can’t seem to get anything to work properly. As I enter new wins or losses the win rate percentage changes but the color fill stays the original color from the first win or loss entry.
Thanks,
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%.
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%.
