How to use releative refrences in conditional formating??
Solved/Closed
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Dec 15, 2014 at 04:48 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 18, 2014 at 01:03 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 18, 2014 at 01:03 PM
Related:
- How to use releative refrences in conditional formating??
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- How to change time format in whatsapp - Guide
- How to clear formatting in excel - Guide
- "Publish your article in rss format for other websites to syndicate" - Video Games Forum
5 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 15, 2014 at 10:48 AM
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.
Why not to use individual formula at Conditional Formatting to perform this?
I hope it helps.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 17, 2014 at 12:45 PM
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.
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 December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Dec 17, 2014 at 11:31 PM
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.
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 December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Dec 15, 2014 at 11:39 PM
Dec 15, 2014 at 11:39 PM
EXAMPLE
ArashMan
Posts
38
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
Dec 17, 2014 at 11:34 PM
Dec 17, 2014 at 11:34 PM
i hope i can say what i want
but its green becuse its based on C5
but its green becuse its based on C5
Didn't find the answer you are looking for?
Ask a question
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 18, 2014 at 01:03 PM
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
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
Dec 15, 2014 at 11:39 PM
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
Dec 16, 2014 at 01:43 AM