Conditional Formating on more than one cell

Closed
AB - Feb 8, 2012 at 07:26 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2012 at 10:30 AM
Hello,

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?

many thanks
AB

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 9, 2012 at 10:30 AM
Hi AB,

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.

Best regards,
Troaw
0