Linking a Word to a Fill pattern, Excel 2011 for Mac

[ross.collier]

Hi there, just wondering if it is possible to link a call (either word or number ) to a pattern.... I am trying to build up a ground profile which i have set out in a grid with the x axis being depth and y being along the ground. I then want to select clay for example from a drop down menu i created in validation and then it change the cell next to it to the fill pattern corresponding to clay. Is this possible. sorry for the rubbish explanation. Many thanks. Ross

 

[Andrew Poulsom]

You can use Conditional Formatting with a formula eg =A1="clay". More here:

http://www.dummies.com/how-to/content/office-2011-for-mac-choosing-conditional-formattin.html