Hello,
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.
Best regards,
bin_bash