Conditional formatting for cells

jb@59069
jb@59069 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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.

Thank you.

RetainerSummary_15Oct2018.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!