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

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

Conditional Formatting colour cells
Rj 45 colour code - Guide
Clear only the formatting from the selected cell (leaving the content) - Guide
Phone formatting software for pc - Download - File management
Based on the cell values in cells b77 - Excel Forum
How to change whatsapp notification colour - Guide

4 responses

Answer 1 / 4

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

alhaddadi Posts 14 Registration date Wednesday February 8, 2017 Status Member Last seen July 13, 2020
Feb 16, 2017 at 03:05 PM

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

Answer 2 / 4

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

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

Answer 3 / 4

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

Answer 4 / 4

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

Highlight cell if another cell contains specific text

Hello,

I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 has 'n/a'. Any suggestions for which formula to use?

Any help would be greatly appreciated!

How to use conditional format based on text?

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

help me to add particular cells

Hello,

i want to sum particular cells when a number consists in a cell

eg:-

=IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0)

it calculates all b77 to bh77 if any cell b81 to bh81 contains 7
i want a formula to calculate like if

b81=7, x81=7, ...... , bh81=7....

sum(b77+x77+......+bh77)

please help me to solve this issue..

Fill adjacent cell with number from text answer

Hello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down box, I would like the adjacent cell to poulate with the number (eg Minor injury = 4) I have to do it for the three blank columns Any help will be much appreciated. Thanks, Mitch.

Best Colour Prediction Games

I am searching for colour prediction game. Suggest interesting games.

Similar discussions

Subscribe To Our Newsletter!