Creating formulas

[Rikki Walker]

Is there any information available for creating formulas? eg. I would like to create a formula which allows numerous cells to look the same (fill colour only) depending on information another cell contains.

 

[mvptomlinson]

Perhaps:

http://www.contextures.com/xlCondFormat02.html