R r_2 Member Apr 9, 2015 #1 hi, need the conditional formatting , where if two selected rows are not have same text or numerical will highlight the 1st column. EX if A<>B, highlight A, RED. in attachment the requirement is, C<>G, highlight C, RED. D<>I, highlight D, Green. Attachments conditional formatting.xlsx conditional formatting.xlsx 10.4 KB · Views: 0
hi, need the conditional formatting , where if two selected rows are not have same text or numerical will highlight the 1st column. EX if A<>B, highlight A, RED. in attachment the requirement is, C<>G, highlight C, RED. D<>I, highlight D, Green.
Luke M Excel Ninja Staff member Apr 9, 2015 #2 Hi r_2, You can set up 2 conditional formatting rules like so: Attachments conditional formatting LM.xlsx conditional formatting LM.xlsx 12 KB · Views: 0
