excel - Coloring Rows Based On Conditions in Two Columns -
in column b , column c have values of 11, 22 , 33 in various cells. rows colored if 11, 22 or 33 in row in either column b or column c.
i have tried conditional formatting cannot formula work correctly.
either vba or conditional formatting fine.
select columns formatted , apply next cf formula rule:
=or($b1=11,$b1=22,$b1=33,$c1=11,$c1=22,$c1=33) excel excel-vba formatting conditional-formatting
No comments:
Post a Comment