Quote:
Originally Posted by genevievebr0
A- It would be nice if you could apply the rules to all of the rows. If there is no limit to the number of rows, could you put the rules from row 4 to 1000?
|
Yup.
Quote:
A) I am not the one who will be correcting the issues. My job will be identify the issues and send them to the Team leaders who will need to verify the data and correct if necessary on a SharePoint file. So it won't be possible for me to see the different rules.
Besides having one rule with the "fill" in a color, another rule with the font in a different color, would you have any other suggestions?
|
Will the team leaders be using the Excel file? If so, then they can work through the conditions.
With so many different rules, I think it would be difficult, if not impossible, to distinguish them. There are only 4 formattable cell characteristics: number, font, borders, and shading.
08-07-2014, 10:44 AM
Similar Threads
Conditional formatting that ignores other formatting rules
Windows 7 64bit 
Office 2010 64bit
Threaded Mode