Conditional Multiple Time Ranges

  • Thread starter Thread starter KT
  • Start date Start date
K

KT

I have pivot tables that pull from a Data Warehouse that regenerates during 6
time ranges each day. I want to put a message on each pivot table that
displays only during these time ranges. I have succeeded in putting a
running clock time on the sheet, but can't figure out how to display my text
for these 6 ranges.

For example, between 8:00 AM and 8:15 AM and 6 other ranges thereafter I
want to display text in a cell on the sheet that provides a message to the
user. How do I specify these ranges and how do I conditionally show the text
for 6 ranges?

Thanks for your help.
 
Hi,

Type the text in a cell (say A5) and colour the font to white (the text
should not be visible). Then apply the following conditional formatting rule
to the cell - Formula is

=and(mod(now(),1)<=time(8,15,0),mod(now(),1)>=time(8,0,0)). Apply the font
to colour black

Now when you refresh the pivot, the conditional formatting should apply

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Perfect solution. Thanks.



Ashish Mathur said:
Hi,

Type the text in a cell (say A5) and colour the font to white (the text
should not be visible). Then apply the following conditional formatting rule
to the cell - Formula is

=and(mod(now(),1)<=time(8,15,0),mod(now(),1)>=time(8,0,0)). Apply the font
to colour black

Now when you refresh the pivot, the conditional formatting should apply

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
Click to expand...
 
Back
Top