=indirect("g"&row())=3

[hro5e]

I have this formula for conditional formatting:

=INDIRECT("G"&ROW())=3

This works perfectly fine, now i want change colour of cells if 2 different rows contain a certain number, so:

Column G = 3
and
Column K = 2 or 3

and the rows should be highlighted only if both columns match?

Help?

 

[Jonmo1]

Glad to help, thanks for the feedback.

It works the way Hotpepper said as well.
It's all about the the row# in the formula being relative to the currently active row.
When using a relative row reference (no $ symbol to left of row #)
$A1 NOT $A$1

When you enter conditional formatting, make note of the currently active row.
The currently active row is shown in the "Name" box, to the left of the formula bar.
Make your formula reflect that row #.
As the formula is entered into subsequent rows, the row# will adjust.