I have 50 columns. Each column represents a different department.
Row 2 shows numerical targets for each department.
Row 3 shows current performance of each department.
Is there a way I can apply conditonal formating to highlight the following:
Cell in Row 3 > Cell in Row 2 = highlight green
Cell in Row 3 < Cell in Row 2 = highlight red
Cell in Row 3 = Cell in Row 2 = highlight amber
I know how to do this for a single cell. But cannot apply the same rule via copy / paste to all the others in the same row without it referencing the target number in the original cell.
Does anyone know if there is a quick simple solution?
The formula you are using is probably: =$A$3>$A$2
The dollar sign in front of A will stop A from becoming B when dragged to the right.
So remove the dollar signs: =A$3>A$2.
Also don't copy-paste, just drag and when done a small square should appear. Clicking it will give you the option to keep format only, thus keeping the values you might have overwrittin by dragging.
