is there anyway to format cells to make them change if and when another cell
changes?

if A1 is greater than 0 then make A2:A15 bold and yellow?

From the Formatconditional Formatting Dialog box. Select Formula Is in the
condition 1 and enter A10 in the adjacent box and set the format to bold.
This format can then be copied to any other cell you require it too.

Hope this helps.



"Daniel Q." wrote:

is there anyway to format cells to make them change if and when another cell
changes?

if A1 is greater than 0 then make A2:A15 bold and yellow?

In Cell A2
Select Conditional formatting
Formula is =$A$10
Format Font Bold and Colour Yellow
Add Condition 2
Formula is =$A$1<=0
Format Font Regular and Colour No Fill

With cell A2 selected click on Format Painter
and select cells A3 to A15

Now any entry in A1 which is greater than 0 will turn A2:A15 Yellow
and a zero or negative number will change it back to no colour

--
Don C


"Daniel Q." wrote:

is there anyway to format cells to make them change if and when another cell
changes?

if A1 is greater than 0 then make A2:A15 bold and yellow?