WeegyAVLover
Distinguished Member
Right,
Been searching for help on this and as yet I have not posted on MrExcel and thought I would try here first.
Here is an extract of what I have and what I want to do.
1 Default Current Allocated
2 A A A
3 B B B
4 A A B
5 A B A
6 B A A
7 B B A
8 B A B
9 A B B
I need to conditionally format cells so that any row ( in this case rows 1 and 2) where all 33 columns match with either the letter A or the Letter B then they are formatted with a Green Fill.
If any columns in the same row do not all match then they need to be formatted with a Red fill.
I am struggling with my formula to create an "And" formula for it?
Hopefully that makes sense and does anyone have any suggestions on the formula?
Been searching for help on this and as yet I have not posted on MrExcel and thought I would try here first.
Here is an extract of what I have and what I want to do.
2 A A A
3 B B B
4 A A B
5 A B A
6 B A A
7 B B A
8 B A B
9 A B B
I need to conditionally format cells so that any row ( in this case rows 1 and 2) where all 33 columns match with either the letter A or the Letter B then they are formatted with a Green Fill.
If any columns in the same row do not all match then they need to be formatted with a Red fill.
I am struggling with my formula to create an "And" formula for it?
Hopefully that makes sense and does anyone have any suggestions on the formula?