| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change font/cell color by Formula
Hey how would I change the font/cell color with a formula, example: =IF(B6="green", fontcolor=green, fontcolor=red) -- exutable ------------------------------------------------------------------------ exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665 View this thread: http://www.excelforum.com/showthread...hreadid=535363 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change font/cell color by Formula
You can't. Not with a formula. Look up Conditional Formatting in Help.
That will do what you want. HTH Otto "exutable" wrote in message ... Hey how would I change the font/cell color with a formula, example: =IF(B6="green", fontcolor=green, fontcolor=red) -- exutable ------------------------------------------------------------------------ exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665 View this thread: http://www.excelforum.com/showthread...hreadid=535363 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change font/cell color by Formula
Formulas cannot format cells.
Have a look at your options under FormatConditional Formatting Condition 1Cell Value is: "green" format green font Note: you can have up to 3 conditions(4 if you count default) Gord Dibben MS Excel MVP On Sun, 23 Apr 2006 17:11:26 -0500, exutable wrote: Hey how would I change the font/cell color with a formula, example: =IF(B6="green", fontcolor=green, fontcolor=red) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change font/cell color by Formula
How would I make it so that if cell B5 says green then C5 is green? I had something like this =IF(C5="green",,) -- exutable ------------------------------------------------------------------------ exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665 View this thread: http://www.excelforum.com/showthread...hreadid=535363 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change font/cell color by Formula
Type "green" into B5 (without the quotes). Select C5. Click on Format -
Conditional Format. Select "Formula Is". In the formula block type =B5="green" with the quotes. Select the Patterns tab and select the green color you want. Click OK. Done HTH Otto "exutable" wrote in message ... How would I make it so that if cell B5 says green then C5 is green? I had something like this =IF(C5="green",,) -- exutable ------------------------------------------------------------------------ exutable's Profile: http://www.excelforum.com/member.php...o&userid=28665 View this thread: http://www.excelforum.com/showthread...hreadid=535363 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i enter a formula in excel that will change a cell value | Excel Worksheet Functions | |||
| formula help to change row colour automatically by some conditions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
Linear Mode
