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 Contributor Last seen December 27, 2022 - Mar 22, 2018 at 12:39 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Mar 22, 2018 at 12:39 PM
Related:
- Apply conditional formatting to multiple rows
- Apply the moderate effect smartart style - Guide
- How to apply @ in laptop - Guide
- Excel conditional formatting based on date - Guide
- Apply watermark to all pages word - Guide
- How to insert multiple rows in microsoft excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Mar 22, 2018 at 12:39 PM
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
'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
