vba - How to count cell colours allocated through a macro in excel 2007? -

-

i have created spreadsheet in excel 2007 teachers monitor progress , attainment based upon various parameters.

to create rules parameters have used set of macros working brilliantly , cells containing student scores change colour depending upon whether progressing at, below or above expected level (yellow, red , green- original know!!).

i trying create 'drop-in' spreadsheet allow staff copy , paste master sheet (which contains of students in year group) , feedback on own class specifically. has worked until came thought easiest part- getting excel count number of different coloured cells in each column. know cannot done through formula unless have xcellcolor add-in (which don't) wrote simple countcolor script using vba.

i can apply formula count coloured cell based upon existing cell colour cannot count coloured cells copied on master spreadsheet. keep getting answer '0' or '29' total number of cells in column!

is way in master spreadsheet allocates cell colour through macro, excel not recognise cell having colour when copied , pasted in 'drop-in' spreadsheet?

i stumped because works columns format colour manually! suggestions?

i use vba sort of thing. type popping bit of code module within master spreadsheet:

public function countcolouredcells(rge range, colour integer) long  dim rge2 range dim count long  each rge2 in rge     if rge2.interior.color = colour         count = count + 1     end if next  countcolouredcells = count  end function

then can use other excel function in workbook: =countcolouredcells(a4:d12,255)

where second argument colour you're interested. 255 red. can find out others recording macro, changing cell colour , looking @ vba.


Popular posts from this blog

How to calculate SNR of signals in MATLAB? -

-
i've encountered simple, yet fundamental problem on calculating snr: there several signals : s1 = original , pure clean signal without noise. n1 = white gaussian noise going added s1. s2 = s1 + n1 (the noisy signal before performing noise-reduction algorithm) s3 = noise-reduced signal (after performing noise reduction algorithm) n2 = s3 - s1 (the amount of noise after performing noise-reduction algorithm) now want compare snr before , after performing noise-reduction algorithm. which signals should consider snr_before!? s1/n1 or s2/n1 ? which signals should consider snr_after!? s3/n1 or s3/n2 ? which commands or functions should use in matlab in order compute snr_before , snr_after? thanks billion putting time on helping me. what know calculating snr before : snrbeforenoise = mean( signal .^ 2 ) / mean( noise .^ 2 ); and snr after : residual_noise = signal - noise_reduced_signal; snr_after = mean( signal .^ 2 ) / mean( residual_noise .^ 2...
Read more

c# - Attempting to upload to FTP: System.Net.WebException: System error -

-
i have api takes in xml , uploads files based on information in xml. uploads on schedule (also xml), , have tested surrounding , know works. i getting error 40% of time on first file attempt upload in each time cycle (time cycle = 45 minutes files, 30 minutes others). here code upload: try { loggerftp.log("uploading file: " + filename, false); // create request. ftpwebrequest request = (ftpwebrequest)webrequest.create(appsettingsftp.ftpurl + @"/" + filename); request.method = webrequestmethods.ftp.uploadfile; request.timeout = 6000000; //set 100 minutes //request.timeout = -1; //set infinite // add login credentials. request.credentials = new networkcredential(appsettingsftp.ftplogin, appsettingsftp.ftppassword); // grab file contents. streamreader sourcestream = new streamreader(appsettingsftp.uploadfiledirectory + filename); byte[] filecontents = encoding.utf8.getbytes(sourcestream.readtoend()); sourcest...
Read more

ios - UISlider customization: how to properly add shadow to custom knob image -

-
Image
i need place custom knob image shadow uislider. far have image of 38x38, of there region defines shadow of knob. now while using image, when slide knob extreme ends actual knob not able cover end points, hence end points visible under transparent region of knob image this code using customize uislider uiimage *slidebtimg = [uiimage imagenamed:sliderknobimg]; [self.ratingslider setthumbimage:slidebtimg forstate:uicontrolstatenormal]; [self.ratingslider setthumbimage:slidebtimg forstate:uicontrolstatehighlighted]; how can implement custom knob shadow beneath it, covering end points?? look inside uislider.h , there methods let customize slider knob , track needed. (ios 2.0 , above) // lets subclass lay out track , thumb needed - (cgrect)minimumvalueimagerectforbounds:(cgrect)bounds; - (cgrect)maximumvalueimagerectforbounds:(cgrect)bounds; - (cgrect)trackrectforbounds:(cgrect)bounds; - (cgrect)thumbrectforbounds:(cgrect)bounds trackrect:(cgrect)rect value:...
Read more