Applying conditional formatting rule to other rows

Closed
FrejaOlsen Posts 1 Registration date Thursday March 22, 2018 Status Member Last seen March 22, 2018 - Mar 22, 2018 at 09:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 22, 2018 at 12:39 PM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 22, 2018 at 12:39 PM
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