Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Formula - Excel '97
Hi,
I'm using the following formula for my criteria and it doesn't work :- =AND(D16:D1013="Mid-Term", (F16:F1013="Yes")) D16:D1013=Mid-Term F16:F1013=Yes I need both of the criteria to be met for the formatting to be applied. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Formula - Excel '97
=AND(COUNTIF(D16:D1013,"Mid-Term") =
ROWS(D16:D1013),COUNTIF(F16:F1013,"Yes") = ROWS(F16:F1013)) -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "Phendrena" wrote in message ... Hi, I'm using the following formula for my criteria and it doesn't work :- =AND(D16:D1013="Mid-Term", (F16:F1013="Yes")) D16:D1013=Mid-Term F16:F1013=Yes I need both of the criteria to be met for the formatting to be applied. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Formula - Excel '97
hi,
Thanks for the reply. I'm not able to get this working though. The formatting still isn't being applied. Any suggestions as to why. I've copied it as show below, and nothing and i've also copied it and not had any luck. "Tim Zych" wrote: =AND(COUNTIF(D16:D1013,"Mid-Term") = ROWS(D16:D1013),COUNTIF(F16:F1013,"Yes") = ROWS(F16:F1013)) -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "Phendrena" wrote in message ... Hi, I'm using the following formula for my criteria and it doesn't work :- =AND(D16:D1013="Mid-Term", (F16:F1013="Yes")) D16:D1013=Mid-Term F16:F1013=Yes I need both of the criteria to be met for the formatting to be applied. Any suggestions? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - Formula - Excel '97
Sometimes the cell references get screwed up in conditional formatting. Make
sure the references are what you think they should be, or use absolute references. =AND(COUNTIF($D$16:$D$1013,"Mid-Term") = ROWS($D$16$:D$1013),COUNTIF($F$16:$F$1013,"Yes") = ROWS($F$16:$F$1013)) -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "Phendrena" wrote in message ... hi, Thanks for the reply. I'm not able to get this working though. The formatting still isn't being applied. Any suggestions as to why. I've copied it as show below, and nothing and i've also copied it and not had any luck. "Tim Zych" wrote: =AND(COUNTIF(D16:D1013,"Mid-Term") = ROWS(D16:D1013),COUNTIF(F16:F1013,"Yes") = ROWS(F16:F1013)) -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "Phendrena" wrote in message ... Hi, I'm using the following formula for my criteria and it doesn't work :- =AND(D16:D1013="Mid-Term", (F16:F1013="Yes")) D16:D1013=Mid-Term F16:F1013=Yes I need both of the criteria to be met for the formatting to be applied. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing Formula For conditional Formatting Using Excel 2000 | Excel Discussion (Misc queries) | |||
Using an If Formula with Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting-If Formula | Excel Worksheet Functions | |||
Excel Formula using Conditional Formatting | Setting up and Configuration of Excel | |||
Conditional Formatting Formula | Excel Programming |