Using Conditional Formatting and ColorFunction?

[SDJ98]

Hi All,

I have a spreadsheet with a bunch of different metrics (in the columns). My conditional formatting is set to shade the cell if they meet a certain threshold, but some are things like letter grades and others are numbers. My plan was to then count the number of shaded cells at the end. I've got the colorfunction working, however it will not work with conditional formatting. My understanding is that conditional formatting doesn't change the actual cell color.

Is there any way to modify the two or perhaps add in another function. My only other option is to sum about 25 columns x 150 rows manually (looking at the shaded cells and just counting in my head), so any help is GREATLY appreciated.

Thanks.

 

[GlennUK]

I see what you mean ... I just had a look at Chip's code and it doesn't work for that. Can I ask why you don't use COUNTIFs operating with the relevant conditions? Like =COUNTIF(C2:C4,">"&A1)

 

[SDJ98]

actually this seems to work, thanks so much. I don't know why I didn't think about the simplest solution other than the fact that I have so much data to do it on (about 40 columns or so), but once I set it up once, I should be fine.

Thanks

 

[GlennUK]

That's great!