ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   changing colors of font in functions (https://www.excelbanter.com/excel-worksheet-functions/62678-changing-colors-font-functions.html)

andreee

changing colors of font in functions
 
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!

Arvi Laanemets

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!





All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com