Using Countif and if to count text then format result compared to another cell

Hi I have a countif formula =COUNTIF(Wed10:Wed51, "HPT" to count the number of times HPT shows in a column. I want to format the result by color compared to another cell. For example: i need 5 however; the countif returns 4(counts 4 HPT in the column) I want the 4 to show red, if it's equal = black, if it's higher than green. How(if possible) can I apply that formula to the cell with the countif already there? is it possible?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!