V Veeru106 Member May 18, 2018 #1 Hi, I am looking for condition formatting help Where we have 2 tables….first table cell B2 get highlighted because it is more than A2 Second table here we want cell B7 to be highlighted , only if B7 is less than A7 and B2 is more than A2 Thanks Attachments Cond.xlsx 8 KB · Views: 6
Hi, I am looking for condition formatting help Where we have 2 tables….first table cell B2 get highlighted because it is more than A2 Second table here we want cell B7 to be highlighted , only if B7 is less than A7 and B2 is more than A2 Thanks
Ashhu Active Member May 18, 2018 #2 apply this rule in ConFor for that cell =AND($B$2>$A$2,$B$7<$A$7)