Forum Discussion
Conditional formatting 2 sum cells
Hello, I have a spreadsheet that tracks clinical supervision hours. One column sums individual supervision (F55) and the other group supervision (G55). There is a limit with group supervision ho...
m_tarler that worked! Thanks!
Now, what if I want G55 to still turn red when I reach the max 100 hours of the group supervision and F55 to turn green once the other 100 hours are reached? So, it'll still go off the sum of those 2 cells but turn different colors for different amounts.
those are separate conditonal format rules. and if needed you can move rules up or down or select 'stop if true' to make 1 rule 'override' another rule
wait after re-reading it all I THINK you want the above 'special' rule to be applied to ONLY F55 (or column F) the formula is the same but you only want the cells in column F (or only F55) to apply to that sum rule.
- So I could just follow the steps that you gave me and just apply to F55? G55 is already set to turn red and stop calculating after 100 hours.
- yes. see above edit to my last comment (my edit crossed the ether with your reply. lol)
- Ha! I got it! Thanks so much for your help!!