ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Making Font Color Changes in IF Statements (https://www.excelbanter.com/excel-worksheet-functions/36540-making-font-color-changes-if-statements.html)

BigEyedFish

Making Font Color Changes in IF Statements
 
For example (I know this isn't right, but....it would go something like this)

If (X, FONT=RED, FONT=BLACK)

Can I even do this? If so how?

JE McGimpsey

Take a look in Help at Conditional Formatting...


In article ,
"BigEyedFish" wrote:

For example (I know this isn't right, but....it would go something like this)

If (X, FONT=RED, FONT=BLACK)

Can I even do this? If so how?


Ron de Bruin

Hi BigEyedFish

Use Conditional Formatting, see this site
http://www.contextures.com/xlCondFormat01.html

--
Regards Ron de Bruin
http://www.rondebruin.nl


"BigEyedFish" wrote in message ...
For example (I know this isn't right, but....it would go something like this)

If (X, FONT=RED, FONT=BLACK)

Can I even do this? If so how?





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

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