N
november678x
Hello to all,
I realized that Excel has a limit of 3 conditional formats. I read some
post on this can be coded into the sheet but they only refered to
numbers and not text. Does any know how I can code this into the my
sheet? Any help would be appreciated, Thank you
For cell range B7:B26
If text contains "POI" Color background to "Rose"
If text contains "KFI" Color background to "Tan"
If text contains "EPT" Color background to 'Light yellow"
If text contains "POC" Color background to 'Light green"
If text contains "TPN" Color background to "Pale blue"
If text contains "CII" Color background to 'Lavender"
If text contains "OS" Colot background to "Gray-25%"
If text contains "SP" Color background to 'Light orange"
I realized that Excel has a limit of 3 conditional formats. I read some
post on this can be coded into the sheet but they only refered to
numbers and not text. Does any know how I can code this into the my
sheet? Any help would be appreciated, Thank you
For cell range B7:B26
If text contains "POI" Color background to "Rose"
If text contains "KFI" Color background to "Tan"
If text contains "EPT" Color background to 'Light yellow"
If text contains "POC" Color background to 'Light green"
If text contains "TPN" Color background to "Pale blue"
If text contains "CII" Color background to 'Lavender"
If text contains "OS" Colot background to "Gray-25%"
If text contains "SP" Color background to 'Light orange"