Conditional Formating on more than one cell

[Closed]
Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
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 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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