Conditional formatting for cells

jb@59069

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.

Paul Newcome

Set your conditional formatting for a single column that will highlight only the rows in that column depending on your criteria. You can then clone the rule and adjust which column it is for.

 

Another option would be to flip your layout. Have the dates going down the first column and your summary fields as your columns. That would make setting up your alerts and notifications easier as well.