How to use releative refrences in conditional formating??

Solved/Closed
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 15, 2014 at 04:48 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Dec 18, 2014 at 01:03 PM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Dec 15, 2014 at 10:48 AM
ArashMan, Good afternoon.

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

I hope it helps.
1
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 15, 2014 at 11:39 PM
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
0
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1 > ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015
Dec 16, 2014 at 01:43 AM
i cant remove $ this is my problem
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Dec 17, 2014 at 12:45 PM
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
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 17, 2014 at 11:31 PM
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.
0
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 15, 2014 at 11:39 PM
EXAMPLE
0
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 17, 2014 at 11:34 PM
i hope i can say what i want



but its green becuse its based on C5
0

Didn't find the answer you are looking for?

Ask a question
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Dec 18, 2014 at 01:03 PM
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
0