Solved

Conditional Formatting with Excel - Part 4

Posted on 2011-03-03
8
259 Views
Last Modified: 2012-05-11
Can someone please tell me why the conditional format in Excel will work on D2, but won't work with D3?

Cheers
EE-1-.xlsm
0
Comment
Question by:cpatte7372
8 Comments
 
LVL 9

Accepted Solution

by:
McOz earned 100 total points
ID: 35027515
You need to make the formula a relative reference. Open "Manage Rules", double-click on "Cell value=..." and change

=ROUND($L$2,2)-0.02

to

=ROUND($L2,2)-0.02 (remove dollar)

click apply, and it should work!
0
 
LVL 59

Assisted Solution

by:Saurabh Singh Teotia
Saurabh Singh Teotia earned 100 total points
ID: 35027520

Change the formula to this...

=ROUND($L2,2)-0.02

Saurabh...
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 100 total points
ID: 35027522
You refer to $L$2 in the conditional formatting which means that D3 is looking at L2 not L3 as required. Try removing the $ signs, i.e. make cell value equal to

=ROUND(L2,2)-0.02

regards, barry
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 100 total points
ID: 35027528
Because it is looking at L2 not L3. The formula should be:
=ROUND($L2,2)-0.02
and not
=ROUND($L$2,2)-0.02
0
 
LVL 17

Assisted Solution

by:gtgloner
gtgloner earned 100 total points
ID: 35027529
Try the following formula in cell D3:
=ROUND(L3,2)-0.02

Open in new window

0
 

Author Comment

by:cpatte7372
ID: 35027656
Hi Experts,

Very grateful to you. Working like a dream

Cheers
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35356993
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now