Data with Criteria is in B4:C13
E4:N4 is B Transposed
I want Conditional Format in E4:N4, for B4:B13 marked "Y" in C4:C13
Make more sense in attached
Data with Criteria is in B4:C13
E4:N4 is B Transposed
I want Conditional Format in E4:N4, for B4:B13 marked "Y" in C4:C13
Make more sense in attached
Select E4:N4 and then ...
Maybe CF Formula:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you , this was fast !
Sorry, I made a mistake !
E2:F2 is merged, then g2:h2 is merged ..... !
You're welcome. Thanks for the rep.
Don't use merged cells. Use Centre Across. Looks the same but won't screw you up.
Yes, but i need formula to format over 2 cells now (next to right too)
OK, select E4:X4 before you apply the CF formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks