Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-how?
I am using nested IF staements to check value conditions of cells. As wel as
checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-how?
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Aidan" wrote in message ... I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-how?
Try this link to Chip Pearson's site:
http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
Hi Bob,
Thanks for the reply. The colorindex reference is useful but is it true that I can not use it directly in an IF statement, do I have to use it in VBA coding ? "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.ColourCounter.html for a working solution -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Aidan" wrote in message ... I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
Thanks Pete,
Good link but unfortunately I do not want to have to use VBA Regards Aidan "Pete_UK" wrote: Try this link to Chip Pearson's site: http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
There is no standard function in Excel to return the background colour
of a cell - you have to make your own, and that means a bit of VBA. Pete Aidan wrote: Thanks Pete, Good link but unfortunately I do not want to have to use VBA Regards Aidan "Pete_UK" wrote: Try this link to Chip Pearson's site: http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
It's VBA or nothing, and even the VBA has constraints.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Aidan" wrote in message ... Hi Bob, Thanks for the reply. The colorindex reference is useful but is it true that I can not use it directly in an IF statement, do I have to use it in VBA coding ? "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.ColourCounter.html for a working solution -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Aidan" wrote in message ... I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
What's a guy in the UK doing posting at 2:05 am?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pete_UK" wrote in message oups.com... There is no standard function in Excel to return the background colour of a cell - you have to make your own, and that means a bit of VBA. Pete Aidan wrote: Thanks Pete, Good link but unfortunately I do not want to have to use VBA Regards Aidan "Pete_UK" wrote: Try this link to Chip Pearson's site: http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
I've told you before that I fly with the owls !! <bg
Pete Bob Phillips wrote: What's a guy in the UK doing posting at 2:05 am? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pete_UK" wrote in message oups.com... There is no standard function in Excel to return the background colour of a cell - you have to make your own, and that means a bit of VBA. Pete Aidan wrote: Thanks Pete, Good link but unfortunately I do not want to have to use VBA Regards Aidan "Pete_UK" wrote: Try this link to Chip Pearson's site: http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
That's close to the dawn chorus!
Bob "Pete_UK" wrote in message ups.com... I've told you before that I fly with the owls !! <bg Pete Bob Phillips wrote: What's a guy in the UK doing posting at 2:05 am? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pete_UK" wrote in message oups.com... There is no standard function in Excel to return the background colour of a cell - you have to make your own, and that means a bit of VBA. Pete Aidan wrote: Thanks Pete, Good link but unfortunately I do not want to have to use VBA Regards Aidan "Pete_UK" wrote: Try this link to Chip Pearson's site: http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
And I was back in action for 8:30am !! All you sleepy-heads who need 8
hours sleep - you waste so much of your life <vbg Pete Bob Phillips wrote: That's close to the dawn chorus! Bob "Pete_UK" wrote in message ups.com... I've told you before that I fly with the owls !! <bg Pete Bob Phillips wrote: What's a guy in the UK doing posting at 2:05 am? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Pete_UK" wrote in message oups.com... There is no standard function in Excel to return the background colour of a cell - you have to make your own, and that means a bit of VBA. Pete Aidan wrote: Thanks Pete, Good link but unfortunately I do not want to have to use VBA Regards Aidan "Pete_UK" wrote: Try this link to Chip Pearson's site: http://www.cpearson.com/excel/colors.htm A user-defined function can return the background colour of a cell, so you could use this in your formula. Hope this helps. Pete Aidan wrote: I am using nested IF staements to check value conditions of cells. As wel as checking for blanks and acceptable values I want to check if the Cell Pattern < Red. Can this final check be done in the IF statement. Appreciate any help ? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to use an IF Statement in excel to check cell pattern-h
Mate, as I get older, I need more.
Bob "Pete_UK" wrote in message ups.com... And I was back in action for 8:30am !! All you sleepy-heads who need 8 hours sleep - you waste so much of your life <vbg Pete Bob Phillips wrote: That's close to the dawn chorus! Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
How do I add a check mark in a cell in a spreadsheet in Excel? | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |