Active Member
August 19, 2016
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?
VIP
Trusted Members
June 25, 2016
Active Member
August 19, 2016
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.
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Active Member
August 19, 2016
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
1 Guest(s)