I have an Excel sheet with three conditional formatting rules to enable easier reading of the data portrayed in the sheet but am getting unexpected results.
compares a task reference in column D and adds a border to the bottom cell when the task reference changes
in column A I have the following formula:
This alternates the value in column A between 1 and 0 based on the change of task reference in column D. This then formats a shade of green for the lines equal to 1. The appearrance of the report is now green and white shading alternating with change in task reference.
Checks that the Task reference is included in the summary reports on other sheets, if not it highlights red.
Rules 1 & 3 seem to work fine. However rule 2 works but some rows end up with a different shade of green.
See attached screen shot.