Conditional Formatting colour cells [Closed]

Report
Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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

4 replies

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020

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
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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
Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020

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
Posts
14
Registration date
Wednesday February 8, 2017
Status
Member
Last seen
July 13, 2020

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
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
Thanks for the feedback.
Glad to be of help.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!