Conditional formatting for cells
I have a Retainer Budget Summary that I need some help with conditional formatting, please. I have attached a snip of the summary.
How can I set conditional formatting to change colors of values in individual cells when:
1) Billed Hours reaches 75%, 85%, 95% of Budgeted Hours;
2) Hours Remaining exceeds Budgeted Hours (value is < 0)
It seems that since conditional formatting only works on the column, that formatting for rows or cells is not available?
Or what am I missing?
Is there a way to have an RYG ball or flag column(s) that would trigger based on formula(s) keyed on the comparative values or negative value?
Can a notification/alert be triggered on any one of the above?
I've been racking my brain and pouring through all the videos and community searches I can think of.
Help Article Resources
Check out the Formula Handbook template!