In Excel, conditional format (font red) referencing another cell? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Christine Hemphill 8/9/2006 10:47 AM PST   Question   I want to do a conditional format to make cell A1 have red font if cell B1 is equal to a certain value (text). Can I do a conditional format on a cell referencing another cell?     Was this post helpful to you?         Reply |   Top           SteveG 8/9/2006 10:58 AM PST   Answer   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?action=getinfo&userid=7571 View this thread: http://www.excelforum.com/showthread.php?threadid=570036     Was this post helpful to you?         Reply |   Top           Christine Hemphill 8/9/2006 11:00 AM PST   Thank you!!! I just found that answer on another posting. Thank you so much for your speedy help!!! "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?action=getinfo&userid=7571 > View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > >     Was this post helpful to you?         Reply |   Top           Kyle 10/2/2008 12:10 PM PST   do you remember where you found your answer? or can you explain your answer to us? we are using Excel 2007. thank you -Kyle "Christine Hemphill" wrote: > Thank you!!! I just found that answer on another posting. Thank you so much > for your speedy help!!! > > "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?action=getinfo&userid=7571 > > View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > > > >     Was this post helpful to you?         Reply |   Top           Please explain more specifically 5/2/2008 3:06 PM PST   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?action=getinfo&userid=7571 > View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > >     Was this post helpful to you?         Reply |   Top           Gord Dibben 5/2/2008 3:22 PM PST   Click on the dropdown arrow at Format>CF>Condition1 "Cell Value is" Gord Dibben MS Excel MVP On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 >> View this thread: http://www.excelforum.com/showthread.php?threadid=570036 >> >>     Was this post helpful to you?         Reply |   Top           Steve 5/31/2008 8:44 AM PST   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 Format>CF>Condition1 "Cell Value is" > > > Gord Dibben MS Excel MVP > > On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please > explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 > >> View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > >> > >> > >     Was this post helpful to you?         Reply |   Top           T. Valko 5/31/2008 10:16 AM PST   Can you be be more specific? Need more detail. -- Biff Microsoft Excel MVP "Steve" <Steve@discussions.microsoft.com> wrote in message news:C75A7CA7-4C19-4911-8279-F766E656612C@microsoft.com... > 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 Format>CF>Condition1 "Cell Value is" >> >> >> Gord Dibben MS Excel MVP >> >> On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically >> <Please >> explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 >> >> View this thread: >> >> http://www.excelforum.com/showthread.php?threadid=570036 >> >> >> >> >> >>     Was this post helpful to you?         Reply |   Top           cerkit 8/27/2009 3:24 PM PST   I am also looking for a way to do this -- use a 2-color gradient fill *based on the value of a different cell*. Did you ever find a solution (or does anyone else have one)? "Steve" wrote: > 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 Format>CF>Condition1 "Cell Value is" > > > > > > Gord Dibben MS Excel MVP > > > > On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please > > explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 > > >> View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > > >> > > >> > > > >     Was this post helpful to you?         Reply |   Top           Gord Dibben 8/29/2009 9:00 AM PST   Select A1 CF>New Rule>Use a formula> =D1="mytext" or =D1>100 Format>Fill Effects>Gradient.................make your choice of color(s) and gradient type. Gord Dibben MS Excel MVP On Thu, 27 Aug 2009 15:25:01 -0700, cerkit <cerkit@discussions.microsoft.com> wrote: >I am also looking for a way to do this -- use a 2-color gradient fill *based >on the value of a different cell*. > >Did you ever find a solution (or does anyone else have one)? > >"Steve" wrote: > >> 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 Format>CF>Condition1 "Cell Value is" >> > >> > >> > Gord Dibben MS Excel MVP >> > >> > On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please >> > explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 >> > >> View this thread: http://www.excelforum.com/showthread.php?threadid=570036 >> > >> >> > >> >> > >> >     Was this post helpful to you?         Reply |   Top           Brian 2/5/2009 11:26 AM PST   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 brian_watson@interact.ccsd.net "Gord Dibben" wrote: > Click on the dropdown arrow at Format>CF>Condition1 "Cell Value is" > > > Gord Dibben MS Excel MVP > > On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please > explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 > >> View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > >> > >> > >     Was this post helpful to you?         Reply |   Top           Gord Dibben 2/5/2009 2:19 PM PST   Select the blank cell..........say A1 Home tab>Styles>Conditional Formatting>Manage Rules New Rule>Use a Formula to determine............ =B1=50% Format to a fill color and OK Gord On Thu, 5 Feb 2009 11:41:04 -0800, Brian <Brian@discussions.microsoft.com> 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 >brian_watson@interact.ccsd.net > >"Gord Dibben" wrote: > >> Click on the dropdown arrow at Format>CF>Condition1 "Cell Value is" >> >> >> Gord Dibben MS Excel MVP >> >> On Fri, 2 May 2008 15:07:01 -0700, Please explain more specifically <Please >> explain more specifically@discussions.microsoft.com> 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?action=getinfo&userid=7571 >> >> View this thread: http://www.excelforum.com/showthread.php?threadid=570036 >> >> >> >> >> >>     Was this post helpful to you?         Reply |   Top           KMorris 6/12/2008 2:47 AM PST   Christine< In Excell 2007, I want to be able to set a formula for a single cell (c3) such that it turns red when its numerical contents are =not(a1+b1 = c3) and the cell turns green when its numerical contents =(a1+b1=c3). How do I set both of these condiions for a single cell in Excel 2007? Thanks, Karen "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?action=getinfo&userid=7571 > View this thread: http://www.excelforum.com/showthread.php?threadid=570036 > >     Was this post helpful to you?         Reply |   Top           T. Valko 6/12/2008 9:50 AM PST   Select cell C3 Goto Home tab>Styles>Conditional Formatting>Manage Rules Click New Rule>Use a formula to determine... Format values where this formula is true: =AND(COUNT(A1,B1,C3)=3,C3<>A1+B1) Click the Format button Select the desired style(s) OK>OK Click New Rule again and repeat the above proccess for the second condition. Use this formula: =AND(COUNT(A1,B1,C3)=3,C3=A1+B1) Then, OK>OK>Apply>OK -- Biff Microsoft Excel MVP "KMorris" <KMorris@discussions.microsoft.com> wrote in message news:26FC85C9-8E21-43E4-9BF0-AD9F6A288E13@microsoft.com... > Christine< > > In Excell 2007, I want to be able to set a formula for a single cell (c3) > such that it turns red when its numerical contents are =not(a1+b1 = c3) > and > the cell turns green when its numerical contents =(a1+b1=c3). How do I > set > both of these condiions for a single cell in Excel 2007? > > Thanks, > > Karen > > "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?action=getinfo&userid=7571 >> View this thread: >> http://www.excelforum.com/showthread.php?threadid=570036 >> >>     Was this post helpful to you?         Reply |   Top           KMorris 6/12/2008 10:44 AM PST   Biff, Thanks, but I'm not clear why the command now needs to include the AND(COUNT(a1,b1,c3)=3 statement prior to what used to be the =(c3=a1 +b1) statement. What are we now telling Excel to do in that first portion of the statement? "T. Valko" wrote: > Select cell C3 > > Goto Home tab>Styles>Conditional Formatting>Manage Rules > > Click New Rule>Use a formula to determine... > Format values where this formula is true: > =AND(COUNT(A1,B1,C3)=3,C3<>A1+B1) > Click the Format button > Select the desired style(s) > OK>OK > Click New Rule again and repeat the above proccess for the second > condition. Use this formula: > =AND(COUNT(A1,B1,C3)=3,C3=A1+B1) > > Then, OK>OK>Apply>OK > > > -- > Biff > Microsoft Excel MVP > > > "KMorris" <KMorris@discussions.microsoft.com> wrote in message > news:26FC85C9-8E21-43E4-9BF0-AD9F6A288E13@microsoft.com... > > Christine< > > > > In Excell 2007, I want to be able to set a formula for a single cell (c3) > > such that it turns red when its numerical contents are =not(a1+b1 = c3) > > and > > the cell turns green when its numerical contents =(a1+b1=c3). How do I > > set > > both of these condiions for a single cell in Excel 2007? > > > > Thanks, > > > > Karen > > > > "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?action=getinfo&userid=7571 > >> View this thread: > >> http://www.excelforum.com/showthread.php?threadid=570036 > >> > >> > > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies     More...