• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

Conditional Formatting with Excel - Part 4

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
cpatte7372
Asked:
cpatte7372
5 Solutions
 
McOzCommented:
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
 
Saurabh Singh TeotiaCommented:

Change the formula to this...

=ROUND($L2,2)-0.02

Saurabh...
0
 
barry houdiniCommented:
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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Rory ArchibaldCommented:
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
 
gtglonerCommented:
Try the following formula in cell D3:
=ROUND(L3,2)-0.02

Open in new window

0
 
cpatte7372Author Commented:
Hi Experts,

Very grateful to you. Working like a dream

Cheers
0
 
TracyVBA DeveloperCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now