Applying conditional formatting rule to other rows

[Closed]
Report
Posts
1
Registration date
Thursday March 22, 2018
Status
Member
Last seen
March 22, 2018
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
I have a row with multiple cells. two cells have drop down lists. If the first cell has value "A" from the dropdownlist, and cell 2 has value "B" from dropdownlist, both cells should become green.
I have solved this by the command: =AND($A$1=B20;$B$1=C21) , in conditional formatting.
B20 and C21 are location for the dropdownlist values.
When adding a new row, i cant get the formatting rule to apply.
I have tried to remove $ and i have tried using the format pencil.
Can anyone help me make it work?

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
hi Freja,

'I have a row with multiple cells'
All rows have multiple cells, hihi.

' If the first cell has value "A" from the dropdownlist, and cell 2 has value "B" from dropdownlist, both cells should become green.'
Shouldn't your formula look like this:
=AND($B$20="A",$C$21="B")

Inserting a row above cell B20 will drop the formatted cells down, but will keep their format.

Does this make sense? If not, could you shine a brighter light on your query?

Best regards,
Trowa