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    
post Feb 16 2017, 03:58 PM

Posts: 1,025
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    18th March 2018 - 02:11 PM