Change format of one cell based on another

[Tim M]

Hi.

How do I change the format of one cell eg make the fill
colour of cell A1 yellow, based on another eg if cell A4
is greater than 100%?

Thanks.

 

[duane]

format...conditional formattin

 

[Tim M]

Thanks, but how do you reference another cell?

 

[duane]

in conditional formatting under condition 1 select "formula is" and the
put in the formula you wan

 

[Max]

How do I change the format of one cell
eg make the fill colour of cell A1 yellow,
based on another eg if cell A4
is greater than 100%?

Try this ..

Select A1

Click Format > Conditional Formatting

Make the settings under Condition 1:
Formula Is | =A4>1
Click Format button > Patterns tab > Yellow? > Ok

Click OK at the main dialog