Conditional Formating specific to Filtered Results

**MDuffy** · 08-09-2010, 07:55 AM

Hi,

Is it possible to set conditional formating on a spreadsheet so that a table of data can be coloured white (not visable), but when the filters are used at the top of the page the filtered results are coloured in black (visable)?

Thanks,

Michael

**zbor** · 08-09-2010, 08:17 AM

Here, see this...

(last two columns are black font so you can see them

but you can aply rule as well)

**MDuffy** · 08-09-2010, 08:22 AM

Zbor that is perfect, exactly what I wanted. How did you manage it? If I can get that onto mine it would do the job very nicely.

Thanks

**zbor** · 08-09-2010, 08:36 AM

In first cell I divide number of showed cells with number of total cells (in A column)...

Conditional formating looking only at that cell. If it's 1 then it show white font, otherwise black.

= number of showed data / number of total data

= SUBTOTAL(102;$A$3:$A$1000) / COUNT($A$3:$A$1000)

Edit: of course, you don't need extra cell... You can adopt it at CFas for example : =SUBTOTAL(102, $A$3:$A$1000)=COUNT($A$3:$A$1000)

Thread: Conditional Formating specific to Filtered Results

Thread Tools

Display

Conditional Formating specific to Filtered Results

Re: Conditional Formating specific to Filtered Results

Re: Conditional Formating specific to Filtered Results

Re: Conditional Formating specific to Filtered Results

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions