A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Incorporating Cell color fill in an "if" logical function?



 
 
Thread Tools Display Modes
  #21  
Old January 21st, 2009, 10:16 PM posted to microsoft.public.excel.worksheet.functions
jim c
external usenet poster
 
Posts: 5
Default Similar Question

How can I incorporate a format into a if statement?
For example
Sum if Cells fill color is red?
  #22  
Old January 21st, 2009, 10:34 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Similar Question

You'll need VBA
http://www.cpearson.com/excel/colors.aspx
http://xldynamic.com/source/xld.ColourCounter.html
--
David Biddulph

"Jim C" Jim wrote in message
...
How can I incorporate a format into a if statement?
For example
Sum if Cells fill color is red?



  #23  
Old January 22nd, 2009, 02:01 AM posted to microsoft.public.excel.worksheet.functions
Corey[_3_]
external usenet poster
 
Posts: 7
Default Similar Question

Try Conditional Formatting from the Format tool bar.

"Jim C" Jim wrote in message
...
How can I incorporate a format into a if statement?
For example
Sum if Cells fill color is red?



  #24  
Old January 22nd, 2009, 02:14 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Similar Question

Corey

Info only.................you cannot CF on a fill color without using VBA


Gord Dibben MS Excel MVP

On Thu, 22 Jan 2009 12:01:37 +1100, "Corey"
wrote:

Try Conditional Formatting from the Format tool bar.

"Jim C" Jim wrote in message
...
How can I incorporate a format into a if statement?
For example
Sum if Cells fill color is red?



  #25  
Old May 6th, 2009, 07:21 AM posted to microsoft.public.excel.worksheet.functions
lee
external usenet poster
 
Posts: 432
Default Incorporating Cell color fill in an "if" logical function?

Hello there

Wondering if you can help.

I have problem with worksheet at work. Running 2003. I have in some cells
formula with if and hlookup. It picks up colour in cell pending answer. IE
if comes back due then cell says due and changes to yellow if expired then
expired returns andcell changes to red. THese have been set up for some time.
I have had to add new columns and rows. In the new ones they are changing
to due and expired but not picking up colours. I have looked into
conditional formatting but it is blocked and I cannot select it.

Can you advise something please.

Also if can help. I can't merge cells on the new ones I have added. I have
checked and the worksheet is not locked.

Thanks

Lee

"T. Valko" wrote:

I am using vista and excel 2007.


Try this...

Assume the cell in question is A1
Select cell A1
Goto Home tabStylesConditional FormattingManage Rules
Click New RuleUse a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OKOKApply

Now, click New Rule and repeat the process for each of the conditions.

This was much easier in previous versions of Excel!


--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
I have a similar question to this thread...

I have a cell that contains an if statement that returns either I, II, III
or IV depending on criteria. Can I also make the cell turn a different
colour
for each of these results? e.g. (Red for I, Orange for II, etc.) I used to
know how to do this in the old excel, but now I am using vista and excel
2007.

Thanks.

Shawn

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and
insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

I want to identify a specific cell by highlighting it with a cell fill
color
when an "if" statement returns a "ture" response. How do I do this?




  #26  
Old May 6th, 2009, 08:26 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Incorporating Cell color fill in an "if" logical function?

If CF is not available and worksheet is not protected perhaps the workbook
has been shared under ToolsShare Workbook.

Unshare to regain CF capability.


Gord Dibben MS Excel MVP


On Tue, 5 May 2009 23:21:01 -0700, Lee
wrote:

Hello there

Wondering if you can help.

I have problem with worksheet at work. Running 2003. I have in some cells
formula with if and hlookup. It picks up colour in cell pending answer. IE
if comes back due then cell says due and changes to yellow if expired then
expired returns andcell changes to red. THese have been set up for some time.
I have had to add new columns and rows. In the new ones they are changing
to due and expired but not picking up colours. I have looked into
conditional formatting but it is blocked and I cannot select it.

Can you advise something please.

Also if can help. I can't merge cells on the new ones I have added. I have
checked and the worksheet is not locked.

Thanks

Lee

"T. Valko" wrote:

I am using vista and excel 2007.


Try this...

Assume the cell in question is A1
Select cell A1
Goto Home tabStylesConditional FormattingManage Rules
Click New RuleUse a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OKOKApply

Now, click New Rule and repeat the process for each of the conditions.

This was much easier in previous versions of Excel!


--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
I have a similar question to this thread...

I have a cell that contains an if statement that returns either I, II, III
or IV depending on criteria. Can I also make the cell turn a different
colour
for each of these results? e.g. (Red for I, Orange for II, etc.) I used to
know how to do this in the old excel, but now I am using vista and excel
2007.

Thanks.

Shawn

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and
insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

I want to identify a specific cell by highlighting it with a cell fill
color
when an "if" statement returns a "ture" response. How do I do this?





  #27  
Old May 27th, 2009, 05:21 AM posted to microsoft.public.excel.worksheet.functions
Ed R
external usenet poster
 
Posts: 2
Default Incorporating Cell color fill in an "if" logical function?

Is there a way to do this if you are looking for a range of values?
Say
- Turn Green if =16
- Turn Red if cell 16 and = 19
- Turn Pruple of cell 19.

I can't seem to get the middle rule to work. It will run the cell Green but
I can't get the compound rule to cancel out the Green and make it red


"T. Valko" wrote:

I am using vista and excel 2007.


Try this...

Assume the cell in question is A1
Select cell A1
Goto Home tabStylesConditional FormattingManage Rules
Click New RuleUse a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OKOKApply

Now, click New Rule and repeat the process for each of the conditions.

This was much easier in previous versions of Excel!


--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
I have a similar question to this thread...

I have a cell that contains an if statement that returns either I, II, III
or IV depending on criteria. Can I also make the cell turn a different
colour
for each of these results? e.g. (Red for I, Orange for II, etc.) I used to
know how to do this in the old excel, but now I am using vista and excel
2007.

Thanks.

Shawn

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and
insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

I want to identify a specific cell by highlighting it with a cell fill
color
when an "if" statement returns a "ture" response. How do I do this?




  #28  
Old May 27th, 2009, 05:30 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Incorporating Cell color fill in an "if" logical function?

Try this:

=AND(A116,A1=19)

Replace A1 with the actual cell reference

--
Biff
Microsoft Excel MVP


"Ed R" Ed wrote in message
...
Is there a way to do this if you are looking for a range of values?
Say
- Turn Green if =16
- Turn Red if cell 16 and = 19
- Turn Pruple of cell 19.

I can't seem to get the middle rule to work. It will run the cell Green
but
I can't get the compound rule to cancel out the Green and make it red


"T. Valko" wrote:

I am using vista and excel 2007.


Try this...

Assume the cell in question is A1
Select cell A1
Goto Home tabStylesConditional FormattingManage Rules
Click New RuleUse a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OKOKApply

Now, click New Rule and repeat the process for each of the conditions.

This was much easier in previous versions of Excel!


--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
I have a similar question to this thread...

I have a cell that contains an if statement that returns either I, II,
III
or IV depending on criteria. Can I also make the cell turn a different
colour
for each of these results? e.g. (Red for I, Orange for II, etc.) I used
to
know how to do this in the old excel, but now I am using vista and
excel
2007.

Thanks.

Shawn

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and
insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

I want to identify a specific cell by highlighting it with a cell
fill
color
when an "if" statement returns a "ture" response. How do I do this?






  #29  
Old August 4th, 2009, 03:52 PM posted to microsoft.public.excel.worksheet.functions
Brittany N Stinson
external usenet poster
 
Posts: 1
Default Incorporating Cell color fill in an "if" logical function?

Hi I would like to have cells change based on if it is the maximum of a range
of cells. For example 0 1 1 3 2 2
I would like the cell containing 3 to turn red because it is the maximum. I
have looked into the conditional formatting but dont see anything that could
help?

--
Brittany N. Stinson


"T. Valko" wrote:

I am using vista and excel 2007.


Try this...

Assume the cell in question is A1
Select cell A1
Goto Home tabStylesConditional FormattingManage Rules
Click New RuleUse a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OKOKApply

Now, click New Rule and repeat the process for each of the conditions.

This was much easier in previous versions of Excel!


--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
I have a similar question to this thread...

I have a cell that contains an if statement that returns either I, II, III
or IV depending on criteria. Can I also make the cell turn a different
colour
for each of these results? e.g. (Red for I, Orange for II, etc.) I used to
know how to do this in the old excel, but now I am using vista and excel
2007.

Thanks.

Shawn

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and
insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

I want to identify a specific cell by highlighting it with a cell fill
color
when an "if" statement returns a "ture" response. How do I do this?




  #30  
Old August 18th, 2009, 03:35 AM posted to microsoft.public.excel.worksheet.functions
Paul
external usenet poster
 
Posts: 1,312
Default Incorporating Cell color fill in an "if" logical function?

is there any way to write an IF statement that does the following:

=IF(A1=pink,"Yes","No")



"Brittany N Stinson" wrote:

Hi I would like to have cells change based on if it is the maximum of a range
of cells. For example 0 1 1 3 2 2
I would like the cell containing 3 to turn red because it is the maximum. I
have looked into the conditional formatting but dont see anything that could
help?

--
Brittany N. Stinson


"T. Valko" wrote:

I am using vista and excel 2007.


Try this...

Assume the cell in question is A1
Select cell A1
Goto Home tabStylesConditional FormattingManage Rules
Click New RuleUse a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OKOKApply

Now, click New Rule and repeat the process for each of the conditions.

This was much easier in previous versions of Excel!


--
Biff
Microsoft Excel MVP


"Shawn" wrote in message
...
I have a similar question to this thread...

I have a cell that contains an if statement that returns either I, II, III
or IV depending on criteria. Can I also make the cell turn a different
colour
for each of these results? e.g. (Red for I, Orange for II, etc.) I used to
know how to do this in the old excel, but now I am using vista and excel
2007.

Thanks.

Shawn

"Miguel Zapico" wrote:

You can use Format-conditional formating, select "Formula is", and
insert
the condition that evaluates to true/false in the text box.

Hope this helps,
Miguel.

"George_Sky" wrote:

I want to identify a specific cell by highlighting it with a cell fill
color
when an "if" statement returns a "ture" response. How do I do this?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent date/scheduling calc needed jct Worksheet Functions 3 February 24th, 2006 02:36 AM
Function syntax to compare cell contents ES Worksheet Functions 2 May 18th, 2005 03:53 PM
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" Timothy L Worksheet Functions 5 August 27th, 2004 02:28 AM
If/And function help Milehigh Worksheet Functions 5 January 30th, 2004 05:15 PM
Convert a Cell Reference to Text Chuck Buker Worksheet Functions 6 September 22nd, 2003 05:04 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.