| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, conditional format (font red) referencing another ce
Dear SteveG
I don't understand how to change the cell value is option to formula is. Can you explain more specifically ? Thanks in advance. Peter "SteveG" wrote: Christine, Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter =B1="Your Text" Click Format, Font select the color you want. Click OK, OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=570036 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, conditional format (font red) referencing another ce
Click on the dropdown arrow at FormatCFCondition1 "Cell Value is"
Gord Dibben MS Excel MVP On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please explain more wrote: Dear SteveG I don't understand how to change the cell value is option to formula is. Can you explain more specifically ? Thanks in advance. Peter "SteveG" wrote: Christine, Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter =B1="Your Text" Click Format, Font select the color you want. Click OK, OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=570036 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, conditional format (font red) referencing another ce
Can you be be more specific? Need more detail.
-- Biff Microsoft Excel MVP "Steve" wrote in message ... Do you know how to do this in the newest version of Excel? The closest thing I can find there is an option to decide *which*cell to format based on a formula, but what I really want to do is use a gradient scale based on value in a different column. Thanks for your help. "Gord Dibben" wrote: Click on the dropdown arrow at FormatCFCondition1 "Cell Value is" Gord Dibben MS Excel MVP On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please explain more wrote: Dear SteveG I don't understand how to change the cell value is option to formula is. Can you explain more specifically ? Thanks in advance. Peter "SteveG" wrote: Christine, Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter =B1="Your Text" Click Format, Font select the color you want. Click OK, OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=570036 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, conditional format (font red) referencing another ce
Ok, I was reading and I have the same issue for Excel 2007, I want to
conditionally format a blank cell, based on the % value of another cell. How do I do that?? Thanks "Gord Dibben" wrote: Click on the dropdown arrow at FormatCFCondition1 "Cell Value is" Gord Dibben MS Excel MVP On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please explain more wrote: Dear SteveG I don't understand how to change the cell value is option to formula is. Can you explain more specifically ? Thanks in advance. Peter "SteveG" wrote: Christine, Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter =B1="Your Text" Click Format, Font select the color you want. Click OK, OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=570036 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel, conditional format (font red) referencing another ce
Select the blank cell..........say A1
Home tabStylesConditional FormattingManage Rules New RuleUse a Formula to determine............ =B1=50% Format to a fill color and OK Gord On Thu, 5 Feb 2009 11:41:04 -0800, Brian wrote: Ok, I was reading and I have the same issue for Excel 2007, I want to conditionally format a blank cell, based on the % value of another cell. How do I do that?? Thanks "Gord Dibben" wrote: Click on the dropdown arrow at FormatCFCondition1 "Cell Value is" Gord Dibben MS Excel MVP On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please explain more wrote: Dear SteveG I don't understand how to change the cell value is option to formula is. Can you explain more specifically ? Thanks in advance. Peter "SteveG" wrote: Christine, Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter =B1="Your Text" Click Format, Font select the color you want. Click OK, OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=570036 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Hybrid Mode
