1)
Is there a way for me to set the conditional formatting in excel so that the formatting would be affected by the contents of another cell?

For example, if I were to enter ‘red’ in cell A1, cell B1 would have red for its cell shading.

2)
Just to ask, is there a way to add more than 3 conditional formatting conditions to any particular cell?

Thanks!!