Applying conditional formatting rule to other rowsClosed

Question

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?

TrowaD · Answer

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

Applying conditional formatting rule to other rows

1 response

Similar discussions

Subscribe To Our Newsletter!