UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Conditional Formatting, Office 2013    
 
   
wornout
post Feb 16 2017, 03:58 PM
Post#1



Posts: 834
Joined: 17-November 13
From: Orewa New Zealand


I have a pivot table Call PivotTable6
it has 2 columns A and B
I have inserted a blank Line after each Item in the design tab
I would like to put a border ontop of each blank row/line
I did try but it just put a border on top of all blank cells
I tried to do the formula with if $A1 and $B1 ="" the format border but it did not work
Plus I get a bit muddled with the applies to box
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    28th March 2017 - 10:56 AM