Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

conditional formatting

Posted on 2013-05-19
1
286 Views
Last Modified: 2013-05-28
conditional formatting active row or less.see the attached file
Book2.xlsm
0
Comment
Question by:Svgmassive
1 Comment
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 39179946
If you want to put the pink highlighting between sections only, select a cell in row 19 and change the formula for the second criteria to:
=AND(COUNTA($B18:$M18)>0,COUNTA($B19:$M19)=0,COUNTA($B20:$M20)>0)

The above formula requires the row before and the row after to contain data, but the row being formatted must be blank.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question