How to use releative refrences in conditional formating??
Solved/Closed
ArashMan
Posts
38
Registration date
Monday 15 December 2014
Status
Member
Last seen
18 February 2015
-
15 Dec 2014 à 04:48
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 18 Dec 2014 à 13:03
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 18 Dec 2014 à 13:03
Related:
- How to use releative refrences in conditional formating??
- How to change date format in excel - Guide
- How to clear formatting in excel - Guide
- How to change date format in openoffice - Guide
- Excel conditional formatting based on date - Guide
- "Publish your article in rss format for other websites to syndicate" - Guide
5 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
15 Dec 2014 à 10:48
15 Dec 2014 à 10:48
ArashMan, Good afternoon.
Why not to use individual formula at Conditional Formatting to perform this?
I hope it helps.
Why not to use individual formula at Conditional Formatting to perform this?
I hope it helps.
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Dec 2014 à 12:45
17 Dec 2014 à 12:45
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.
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.
ArashMan
Posts
38
Registration date
Monday 15 December 2014
Status
Member
Last seen
18 February 2015
1
17 Dec 2014 à 23:31
17 Dec 2014 à 23:31
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.
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.
ArashMan
Posts
38
Registration date
Monday 15 December 2014
Status
Member
Last seen
18 February 2015
1
15 Dec 2014 à 23:39
15 Dec 2014 à 23:39
EXAMPLE
ArashMan
Posts
38
Registration date
Monday 15 December 2014
Status
Member
Last seen
18 February 2015
1
17 Dec 2014 à 23:34
17 Dec 2014 à 23:34
i hope i can say what i want
but its green becuse its based on C5
but its green becuse its based on C5
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
18 Dec 2014 à 13:03
18 Dec 2014 à 13:03
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
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
15 Dec 2014 à 23:39
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
16 Dec 2014 à 01:43