Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel Conditional Formatting

Posted on 2011-09-12
3
Medium Priority
?
286 Views
Last Modified: 2012-05-12
Experts,

Can someone please tell me why this conditional formatting won't work?

Cheers

Carlton
EE-The-Tapev11.xlsm
0
Comment
Question by:cpatte7372
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 36523247
Rather than >$D$3 and >$E$3 remove the $ signs and use >D3 and >E3, that will do a comparison for each row, otherwise you are comparing each row against a fixed row 3

regards, barry
0
 

Author Comment

by:cpatte7372
ID: 36523480
Cheers Bazza :-)

Worked!
0
 

Author Closing Comment

by:cpatte7372
ID: 36523483
Cheers
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

824 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