Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

conditional formatting

Posted on 2014-10-24
2
Medium Priority
?
62 Views
Last Modified: 2014-10-24
Hi,

My conditional formatting in Col S is not working, can anyone see why?
EE.xlsx
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 40401240
You need to remove the $ from before the row numbers - all rows are looking at row 7 at the moment. See attached version of your workbook.
EE--1-.xlsx
0
 

Author Closing Comment

by:Seamus2626
ID: 40401256
Thanks Rory!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

572 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