Conditional format usign COUNTIFS
Closed
miter69
Posts
2
Registration date
Monday 20 July 2009
Status
Member
Last seen
22 July 2009
-
21 Jul 2009 à 11:22
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Jul 2009 à 19:59
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Jul 2009 à 19:59
Related:
- Conditional format usign COUNTIFS
- Dvi format - Guide
- Kingston format utility - Download - Storage
- Hdd low level format tool - Download - Storage
- Hp usb disk storage format tool - Download - Storage
- How to change date format in excel - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
21 Jul 2009 à 21:14
21 Jul 2009 à 21:14
sorry for this simple question. where did you type in the formula
when you click format menu -conditional formula you get conditional format window
under "condition1"
there is a small arrow click that arrow and choose
"formula is"
and then write the formula
if you are going to copy the formatting down you should not have any dollar signs depending upon the condition
when you click format menu -conditional formula you get conditional format window
under "condition1"
there is a small arrow click that arrow and choose
"formula is"
and then write the formula
if you are going to copy the formatting down you should not have any dollar signs depending upon the condition
miter69
Posts
2
Registration date
Monday 20 July 2009
Status
Member
Last seen
22 July 2009
1
22 Jul 2009 à 07:38
22 Jul 2009 à 07:38
Its Excel 2007, so I typed the formula in under conditional format --> New rule --> use a formula to determine which cells to format. This is the exact formula I used under the conditional format......=COUNTIFS(E2:E179,"1",N2:N179,"Y",P2:P179,TRUE) This formula works just fine on its own...that is without trying to use it as a conditional format, and basically all I would like to do is figure out which cells its counting to come up with the number. That is to say that the end result of the formula equals 11, and I would like to know where its getting the 11 from.
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
22 Jul 2009 à 19:59
22 Jul 2009 à 19:59
COUNTIFS(E2:E179,"1",N2:N179,"Y",P2:P179,TRUE)
this gives number of occasions when in column E, 1 occurs and in column N "y" occurs and in column P TRUE occurs. ok that is 11 . on 11 occasions simultaneously these critera occur.
But in conditional format you have to give one more condition
for e.g. if this number is more than 5 color the cell. then in the condition format formula you must write
=COUNTIFS(E2:E179,"1",N2:N179,"Y",P2:P179,TRUE) >5
Hope I have made this clear
this gives number of occasions when in column E, 1 occurs and in column N "y" occurs and in column P TRUE occurs. ok that is 11 . on 11 occasions simultaneously these critera occur.
But in conditional format you have to give one more condition
for e.g. if this number is more than 5 color the cell. then in the condition format formula you must write
=COUNTIFS(E2:E179,"1",N2:N179,"Y",P2:P179,TRUE) >5
Hope I have made this clear
