You can copy the Conditional Formatting to each of the sheet/file.
Hi Ishey You can try using Conditional Formatting. Whenever a specific text (team) is selected, conditional format that cell to the required col...
Hi H R Thanks for your feedback. Happy to know it is working. Cheers Sunny
Give this a try. In C2 enter =IF(COUNTIFS($A$3:$A$4914,A3)>=2,2,1)-COUNTIFS($A$3:$A$4914,A3,$B$3:$B$4914,B3)+1 Sunny
Possibly your column is not wide enough. Try adjust the column width. If it doesn't work then attach your file for us to have a look.
Hi Alan I would use F=1, S=0 and D=-1 and then use the Win/Loss sparkline. This will allow me to see the down/idle time, which I consider to be ...
To include a dash, you can try TEXT(A3,"000-000")
Hi Amy Try changing this line from cel.Value = "0" & cel.Value to cel.Value = Format(cel.Value, "000-000") Hope this helps Sunny
Hi Christopher The form was designed to search by one field. Data in that field must be unique as the form will only search for the 1st occurre...
Hi Christopher Try changing this line of code from RecordRow = Application.Match(CLng(TextBox1.Value), Range("Table1[Record]"), 0) to Reco...
Hi Rafi Don't understand your question. What are you trying to count? Can you attach your file with the expected result and what/how you intend ...
I have to agree with Purfleet. No need to check. Just change the entire column to the required format.
Hi Rafi Just wondering why do you want to count based on cell format? What is the practical use? Sunny
Hi Rafi Thanks for your feedback. Better late than never
Hi Sara See attached. It is a crazy ARRAY formula I modified from here: Good luck