Conditional Formatting colour cells
Closed
alhaddadi
Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020
-
Updated by Ambucias on 12/02/17 at 05:10 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 16, 2017 at 05:43 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 16, 2017 at 05:43 PM
Related:
- Conditional Formatting colour cells
- Crimping colour code - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
4 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 16, 2017 at 08:00 AM
Feb 16, 2017 at 08:00 AM
alhaddadi, Good morning.
This my suggestion for your case.
https://www.sendspace.com/file/67j42t
Please, take a look at it and tell us if it worked for you.
Any doubts call us again.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
This my suggestion for your case.
https://www.sendspace.com/file/67j42t
Please, take a look at it and tell us if it worked for you.
Any doubts call us again.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 12, 2017 at 07:21 AM
Feb 12, 2017 at 07:21 AM
alhaddadi, Good morning.
Please give us more information so we can help you.
Do you need 1% to 70% over what parameter?
Give us a concrete example and the expected result so we can know how you do your calculation.
I'm sure we'll be able to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Please give us more information so we can help you.
Do you need 1% to 70% over what parameter?
Give us a concrete example and the expected result so we can know how you do your calculation.
I'm sure we'll be able to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
alhaddadi
Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020
Feb 13, 2017 at 06:28 AM
Feb 13, 2017 at 06:28 AM
Hi Sir,
My Example is:
Send Date ... duration time ... expected date ... Receive Date ... 70% ... 90%
2017/01/01 ........... 9 ................ 2017/01/10 ......... 2017/01/03 ........ ? ..........?
1. How can I calculate 1% to 70% from duration time (9 days) ... cell color Green
2. How can I calculate 70% to 90% from duration time (9 days) ... cell color Yellow
If you have email I can send the excel file will be easy
My Example is:
Send Date ... duration time ... expected date ... Receive Date ... 70% ... 90%
2017/01/01 ........... 9 ................ 2017/01/10 ......... 2017/01/03 ........ ? ..........?
1. How can I calculate 1% to 70% from duration time (9 days) ... cell color Green
2. How can I calculate 70% to 90% from duration time (9 days) ... cell color Yellow
If you have email I can send the excel file will be easy
alhaddadi
Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020
Feb 16, 2017 at 05:43 AM
Feb 16, 2017 at 05:43 AM
Hi Sir,
My Example is:
A1: 2017/01/01 ... Send Letter
B1: 9 days ... Duration Time
C1: 2017/01/10 ... Expected Date
D1: 2017/01/08 ... Receive Date
E1: 1% - 70% from B1, IF so make cell GREEN color
F1: 70% - 90% from B1, IF so make cell YELLOW color
G1: >= 100 from B1, IF so make cell RED color
I appreciate for any help OR other idea
My Example is:
A1: 2017/01/01 ... Send Letter
B1: 9 days ... Duration Time
C1: 2017/01/10 ... Expected Date
D1: 2017/01/08 ... Receive Date
E1: 1% - 70% from B1, IF so make cell GREEN color
F1: 70% - 90% from B1, IF so make cell YELLOW color
G1: >= 100 from B1, IF so make cell RED color
I appreciate for any help OR other idea
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 16, 2017 at 05:43 PM
Feb 16, 2017 at 05:43 PM
Thanks for the feedback.
Glad to be of help.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Glad to be of help.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Feb 16, 2017 at 03:05 PM
Perfect, i works fine
I will try to use my work on it, and I will inform you
Thank you very much I appreciate you help me