Previous Topic Next Topic

Conditional Formating on more than one cell

Closed
-
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
 -
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

Answer 1 / 1
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
 491
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
Ask a question