example: if cell L1 has a value greater than 0 i would like the text for all
cells on row 1 to change to red / bold. any idea how i would achieve this

thanks in advance

David

Use something called "Conditional Formatting":

Select the relevant Row
From the toold bar select Format
Then Conditional Formating
Leave the first box as Cell Value Is
then Select Greater Than
Then Select 0 in the free type space.
Finally click on the format button just below the free type space and
select the colours you want it to change to.

Regards,
Chris


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=502406

David

Have you tried Conditional Format?

Sofia



Daveed escreveu:

example: if cell L1 has a value greater than 0 i would like the text for all
cells on row 1 to change to red / bold. any idea how i would achieve this

thanks in advance

David

Hi Daveed,
Use conditional formatting.
Select the cells in row 1 that you want formatted this way.
In the main menu bar go FormatConditional formatting...
Click on the down arrow and select Formula Is.
In the box to the right of Formula Is type =$L$10
Click on the Format... button then make the changes for red, bold font
then click OK.
Click OK

Ken Johnson

Thanks. i would only like to apply the formatting to the entire row only if
cell L1 is greater than 0... conditional formatting doesn't seem to work on
this one.

"chalky" wrote:


Use something called "Conditional Formatting":

Select the relevant Row
From the toold bar select Format
Then Conditional Formating
Leave the first box as Cell Value Is
then Select Greater Than
Then Select 0 in the free type space.
Finally click on the format button just below the free type space and
select the colours you want it to change to.

Regards,
Chris


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=502406

thanks Ken. this was what i was looking for though i had to rewrite the
formula to =$L10 so it would work down the page for L2,L3 and so forth.

Many Thanks

David

"Ken Johnson" wrote:

Hi Daveed,
Use conditional formatting.
Select the cells in row 1 that you want formatted this way.
In the main menu bar go FormatConditional formatting...
Click on the down arrow and select Formula Is.
In the box to the right of Formula Is type =$L$10
Click on the Format... button then make the changes for red, bold font
then click OK.
Click OK

Ken Johnson

Great David, thanks for the feedback
Ken Johnson