Previous Topic Next Topic

Conditional Formatting colour cells

Closed
alhaddadi Posts 14 Registration date Wednesday 8 February 2017 Status Member Last seen 13 July 2020 - 12 Feb 2017 à 05:09
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 16 Feb 2017 à 17:43
Hi All,
Its my First topic, am looking forward for help me.

In my Excel file columns :
1. Sending letter Date
2. duration time
3. expected date
4. Receive Date

How can I do :
1. Calculate 1% to 70% from duration time >>> Cell color Green
2. Calculate 70% to 90% from duration time >>> Cell color Yellow
3. When duration time over >>> Cell color Red

I appreciate for any help.
Thanks All
Related:

4 responses

Réponse 1 / 4
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
16 Feb 2017 à 08:00
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
alhaddadi Posts 14 Registration date Wednesday 8 February 2017 Status Member Last seen 13 July 2020
16 Feb 2017 à 15:05
Good morning Sir.

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
Réponse 2 / 4
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
12 Feb 2017 à 07:21
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
alhaddadi Posts 14 Registration date Wednesday 8 February 2017 Status Member Last seen 13 July 2020
13 Feb 2017 à 06:28
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
Réponse 3 / 4
alhaddadi Posts 14 Registration date Wednesday 8 February 2017 Status Member Last seen 13 July 2020
16 Feb 2017 à 05:43
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
Réponse 4 / 4
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
16 Feb 2017 à 17:43
Thanks for the feedback.
Glad to be of help.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão