formatting

D

Daveed

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
 
C

chalky

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
 
K

Ken Johnson

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

Ken Johnson
 
D

Daveed

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.
 
D

Daveed

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

Many Thanks

David
 
Top