ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula results in font color change (https://www.excelbanter.com/excel-worksheet-functions/5445-formula-results-font-color-change.html)

Jeff P November 1st 04 07:58 PM

Formula results in font color change
 
I have a formula that I want to create using the If function. Can I make the
true or false result change the font color in the cell being evaluated?
--
Jeff P

mzehr November 1st 04 08:28 PM

Hi Jeff,
Yes, use conditional formatting. For help getting started see:
http://www.mvps.org/dmcritchie/excel/condfmt.htm
http://www.contextures.com/xlCondFormat01.html
http://j-walk.com/ss/excel/odd/odd07.htm


"Jeff P" wrote:

I have a formula that I want to create using the If function. Can I make the
true or false result change the font color in the cell being evaluated?
--
Jeff P


Frank Kabel November 1st 04 08:28 PM

Hi
see: Format - Conditional Format for this

--
Regards
Frank Kabel
Frankfurt, Germany


Jeff P wrote:
I have a formula that I want to create using the If function. Can I
make the true or false result change the font color in the cell being
evaluated?




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

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