How to use releative refrences in conditional formating?? [Solved/Closed]

Report
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
-
the first picture is the formatting rule of C7 cell



the second picture is the formatting rule of E7 cell which i copy from C7.



as you can see the value is =$C$3 .... =$C$5 But i want this to use E3.....E5 i dont want to change it manually because i want to paste C7 cell to many cells. i cant remove $ (below picture)



what should i do please help

5 replies

Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
139
ArashMan, Good afternoon.

Why not to use individual formula at Conditional Formatting to perform this?

I hope it helps.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Dear Mazzaropi
Because i want to paste the conditional formatting which is in C7 cell to D7,E7,F7,...... and when i did this they all look to C3:C5 cell
D7 must look at D3:D5 E7 must look at E4:E5 and,,,,,
i hope i can tell you what i mean, maybe the below picture can help
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1 >
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015

i cant remove $ this is my problem
Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
139
ArashMan, Good afternoon.

This is a bit confusing.

Do you want to know when the numbers are MIN, MIDPOINT and MAXIMUM as the rule you selected?

Why ALL the results at your image MUST be GREEN?

Please, be a little more clear in your explanation.

I want to help you.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
ok i will explain with more detail
i used this conditional formatting for C7 cell (the picture) when i extend C2:C7 cells to right the color of D7,E7,.... will change base on C3:C5. but i want for example : if D7=D5 then D7 goes red this is what happen now when i extend.
if D7=C3 then it will goes red and i dont want it.
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
EXAMPLE
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
i hope i can say what i want



but its green becuse its based on C5
Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
139
ArashMan, Good afternoon.

You must use the same logic suggested for your other posts.

Take a look at an example I did for you.
http://speedy.sh/d2Xpw/18-12-2014-en-Kioskea-Conditional-Format-by-Position-OK.xlsx

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!