Register
Log In
Unanswered
Home
August 19, 2016
Offline
I have a column of Conditionally Formatted cells where D1 equals 1, then A1 Background fill is Gray. Is this a formula to count these Gray cells without using VBA?
See Answer
Dashboards
June 25, 2016
Offline
Hi bohi
Since only cells with 1 will turn Gray, you might as well just count all the cells with 1's.
August 19, 2016
Offline
Good morning SunnyKow,
I guess I should have included more detail. If D1 = 1, then A1 is Gray. If E1 = 2, then A1 is yellow and if F1 = 3, then A1 is Strikethrough. My intention was to count just the D1 = 1, then A1 is Gray conditional format. Column A shows current progress on a specific task which is updated daily sometimes hourly.
Dashboards
June 25, 2016
Offline
Hi
Are all the colored cells in column A?
August 19, 2016
Offline
Yes but i only interested in counting the Conditional Formatted Gray Cells. Once they turn Yellow or Strikethrough, it's out og my hands. I am aware of the formula to count all 1's, but they all have 1's once they are entered into the spreadsheet.
Dashboards
June 25, 2016
Offline
Can I say that if D is 1 it turns grey but if E also have a 2, it will override with yellow?
So you may have D=1 and E=2 and possibly F=3 all filled in a single row.
You need to find Grey cells with D=1, E=blank and F = blank. Am I correct?
Dashboards
June 25, 2016
Offline
Can you see if this is what you want?
August 19, 2016
Offline
SunnyKow,
Attached is an update to your spreadsheet showing how I have my formulas. Condition 2 overrides condition 1 and condition 3 overrides condition 2
August 19, 2016
Offline
SunnyKow,
Thank you for your help on this issue. Once I started communicating back and forth with you, it occured to me that I was going about this in the wrong way. Instead of trying to figure our how to write a formula for a Conditional Format, why not write a formula for a regular issue. My solution is
=SUMIFS(Sheet1!$F:$F,Sheet1!$W:$W,"1",Sheet1!$X:$X"",Sheet1!$Y:$Y,"") This tells me qty of $F:$F if $W:$W =1 and $X:$X is blank and $Y:$Y is blank.
Thank you for your inspiration
Answers Post
Most Users Ever Online: 57
Currently Online: clark shao
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
