View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default changing colors of font in functions

Hi

Select cell(s). From Format menu, select Conditional Formatting. Set
condition to <Cell Value Is <greater than <1000. Click on Format button,
and set reaction for true condition (p.e. red font color).


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"andreee" wrote in message
...
hello
I would like to change color of font when value of cell is over 10000.
Should I do it using IF function? How should I write it? What commands use
to change color of font?
Thanks!