Forum Discussion
multiple conditional formatting rules for the same cell
Hi, I can't seem to find a formula to help solve this problem. I am creating a Gantt chart that pulls info from multiple sources. I need to find a way to flag a cell when multiple conditional forma...
You could create a third rule that highlights the cell in red and/or places a thick border around the cell. Use this formula that combines the two other formulas:
AND(E$5>='Data Entry Sheet'!$D6,E$5<='Data Entry Sheet'!$E6,NOT(ISBLANK('GEOTECH Schedule'!E$15)))
Make sure that the new rule is listed at the top in the Manage Rules dialog. It will then override the other rules.
HansVogelaar I can't seem to get that third rule to work. Would you have any other suggestions?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
