Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet?
My example is as follows:
I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want to make a visual cue through conditional formatting that will flag the Actual row for a unit, if it duration has exceed the target or planned duration.
However when I make the rule I do not see where I can specify that this rule only applies to row 85 for example.
Thanks for any information that you can provide.