Excel: Format cell based on contents of other cell
In Excel 2003, what's the best way to format a range of cells (e.g. make the text green) based on the contents of a different cell? I know I can use Conditional Formatting to format a cell based on its contents, but this is different.
For example, how could I make the text in A2 through to A10 become green if A1 contains "Yes".