Excel Conditional Formatting on Multiple Sheets

Originally Posted by etaf

you seem to have a lot of the same conditional formatting for different ranges

heres an example of the range
January19!$G$4:$G$19,January19!$G$23:$G$36,January19!$I$4:$M$19,January19!$I$23:$M$36,January19!$O$4:$S$19,January19!$O$23:$S$36,January19!$U$23:$Y$36,January19!$U$4:$Y$19,January19!$AA$4:$AE$19,January19!$AA$23:$AE$36


for the rule
=COUNTIF($C$4:AG37,G4)=2

But you also have
=COUNTIF($C$4:AF37,E4)=2

I suspect the conditional formatting needs going through and verifying each entry and range

Only reason i have the same Conditional Formatting for different ranges is because i did not want it to be applied to the merged cells that says "Weekend" in between, because if i do the range C4 to AG37 or something, than the WEEKEND cell will change color too.

Originally Posted by etaf

Thanks, i see
so the issue is you want to count across multiple sheets, using conditional formatting

Yes please, ive tried the January19! with the cell number but it seems its not working. (or maybe most probably im doing something wrong)
But anyway yea thats what im trying to get
Thank you

I did try, maybe im just not able to grasp it, can some1 do it on my excel sheet and send it back ? (please )

Originally Posted by kvsrinivasamurthy

CF is applied for January19 sheet as example and it is working. Extend the same to other sheet also.
For C4

=AND(SUM(COUNTIF(December18!$C$4:AE37,C4)+COUNTIF(January19!$C$4:AE37,C4))=2,C4<> "WEEKEND")

CF has made excel slow. It is better to go for worksheet event to color cells which is faster.

Thank you, that helped a bit, but now ONLY the 2nd cell is going green, whereas with the conditional formatting both cells go green or yellow or whatever.
I still cant get it 100% right.

Originally Posted by kvsrinivasamurthy

Change 2 in the formula as 3 or 4 and use it other CF for yellow and red.

I understand about the 3 and 4, i have done it on my sheet CF, but as u can see in your Attachment above, the one on sheet1 (Dec) is not lit green, only the second one on sheet2 (Jan) is lit green

Sorry im not trying to be negative or demanding, just want to get the final/perfect solution as i asked up there. I still cant find it.. i tried the links that was posted by etaf, and all the other solutions suggested to me. Unless i am doing something wrong.
Can someone implement it on the worksheet and attach it, just one example. I will greatly appreciate it.

Originally Posted by kvsrinivasamurthy

Pl see file .
I have applied all 3 conditions to January19 sheet. It is working ok .
Only when you apply CF for December19 sheet only cells will get color.
Apply CF to December19 sheet also as I have applied for January19 sheet.
I have completely cleared allCF in December19 sheet.

THANK YOU it actually worked! im gonna mark this as SOLVED, thanks a lot i did it on all the months (on my main file) not the test that goes to December 2019 and it works perfectly.

RESOLVED, Thank You All for The Help!

Ok im embaressed to say that (im new to this site) and i cannot find a way to Resolve or mark it Solved, thats of course IF THERE IS SUCH A THING