How to Make a Cell Turn a Color in a Formula in Excel : Using Microsoft Excel

How to Make a Cell Turn a Color in a Formula in Excel : Using Microsoft Excel

eHowTech

11 лет назад

1,181,887 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Nurawis
Nurawis - 03.10.2023 07:35

Thanks, Ted.

Ответить
CD M
CD M - 28.09.2023 07:24

Great explanation

Ответить
Muhammad Tashfain
Muhammad Tashfain - 10.09.2023 11:04

please can you tell me how can i added specific color values. for exam i just want to added dark green color values where i use dark green color in sheet automatically values will added where i put a formula

Ответить
Luminary
Luminary - 19.06.2023 08:36

Tysm i got an exam

Ответить
31acruz
31acruz - 24.01.2023 06:35

Dude, I don't want any rules, can't I just pick a darn cell and assign it a color ?? seriously.

Ответить
Henry
Henry - 19.12.2022 18:34

Thank you. That was great.

Ответить
DLK Houseplans
DLK Houseplans - 17.11.2022 12:17

You look so much Like Keanu reeves

Ответить
Ndubuisi Uhuo
Ndubuisi Uhuo - 13.10.2022 22:51

Thank you, it was helpful

Ответить
Tracy Best
Tracy Best - 10.10.2022 10:40

What if I have ONE cell, with a RANGE of answers from 1-100, and I want to color code into 4 cats (1-25, 26-50, 51-75, and 76-100) How would I do that?

Ответить
DᴀᴍɴᴇᴅTᴏᴜʀ'87
DᴀᴍɴᴇᴅTᴏᴜʀ'87 - 19.08.2022 22:01

eHow: Whats your name
Ted: My name is Ted.
eHow: Ok Ted, we'll call you Edward Russell for shorten in this video.

Ответить
Ramesh chy
Ramesh chy - 16.08.2022 11:45

Thank you

Ответить
Steven Vadgama
Steven Vadgama - 17.12.2021 03:38

That was really helpful and clearly explained. Thank you very much!

Ответить
Sami Awad
Sami Awad - 13.10.2021 15:27

Thank you Sir. It was exactly what I needed to know; very usefull

Ответить
calendil
calendil - 16.08.2021 11:18

Misleading title.. This is not a formula this is a rule..

Ответить
Surfview Gardens
Surfview Gardens - 16.08.2021 05:42

Great, man! Thanks.

Ответить
NORAISHAH RAMLI
NORAISHAH RAMLI - 31.07.2021 17:52

thank you Sir, it easy and can apply on google sheet too.

Ответить
Firas Faham فراس فحام
Firas Faham فراس فحام - 30.07.2021 21:11

Hey Edward, job well done - thank you.

Ответить
Wheein cannot wheeout
Wheein cannot wheeout - 15.07.2021 10:40

Thank you so so much!

Ответить
Mahfi R
Mahfi R - 03.06.2021 20:01

I'm using Microsoft office 2013. But can't find format. Can you please tell me which office version you are using?

Ответить
JayG
JayG - 30.04.2021 04:44

This was the best example I’ve seen

Ответить
Servant Status Ministries
Servant Status Ministries - 05.03.2021 12:30

Thank you for making this video! Have a blessed day!!!

Ответить
Kevin Solway
Kevin Solway - 08.12.2020 09:57

Doesn't do it in a formula, which the title wrongly says it does.

Ответить
K R TIRUVENGADAM
K R TIRUVENGADAM - 22.10.2020 10:29

Thank you, Sir.

Ответить
Azjargal Batdorj
Azjargal Batdorj - 03.10.2020 00:17

thank you

Ответить
Marc Leon
Marc Leon - 17.09.2020 22:30

Thanks simple & direct.

Ответить
ðлюди иÆ
ðлюди иÆ - 21.08.2020 10:07

10QU sir. STAY BLESSED!!!!

Ответить
Real Islam7865
Real Islam7865 - 04.08.2020 11:57

i am not able to find conditional formating option in my Ms Excel. Anyone can help me????

Ответить
Ibrahim El Oueryaghely
Ibrahim El Oueryaghely - 13.07.2020 21:06

Is there any way to change the font with IF formula??
Condition formatting is nice but not flexible enough.
BTW nice video ;-)

Ответить
jack johnson
jack johnson - 08.07.2020 17:07

I thought your name was ted

Ответить
Zarrow
Zarrow - 06.07.2020 05:13

wish you could do this for one cell only

Ответить
Mark Slavic
Mark Slavic - 04.02.2020 19:55

Thanks, git the answer

Ответить
Happy Trip
Happy Trip - 27.01.2020 15:50

Nice Video Sir. I have a question Sir, how to use conditional formatting on Month.. when i want only the month of January, April and October? can u teach me the formula? thanks

Ответить
Affirmation Avenue
Affirmation Avenue - 25.01.2020 00:31

Your fictional business needs to give fictional Pablo a raise lol

Ответить
shree
shree - 18.12.2019 05:06

Sir,what to do if i want same colour in "total pay" & "emplyee".....
It should change atomatically in same in both the columns

Ответить
Joe Tagliente
Joe Tagliente - 02.12.2019 23:54

Ted you rock! I needed to figure out how to do 2 things in excel and you answered both in 5 minutes. Thank you!

Ответить
Jay Cole
Jay Cole - 22.09.2019 03:09

very helpful

Ответить
Thaer Ihmeidan
Thaer Ihmeidan - 17.09.2019 10:50

simple course, a lot of information

Ответить
Naveen Sangwan
Naveen Sangwan - 28.08.2019 19:16

without conditional formatting do bro

Ответить
nitin khtri
nitin khtri - 09.08.2019 11:20

Hi sir is this possible if I want cell should be change colour after 40 mint after putting a value in cell

Ответить
Minal Ramteke
Minal Ramteke - 18.07.2019 08:12

How to find the font Color as I want to give comment like if font is in red colour then I want in front of that cell as "loss",for blue as "gain" and black as "stable". So can you please help me with this . I have been trying but not getting

Ответить
Kaustav Kumar
Kaustav Kumar - 31.01.2019 18:14

What if it's conditional-formatting with if's; i.e. if x>y then green else red.

Ответить
Dr.Q M
Dr.Q M - 23.01.2019 19:31

Very nice

Ответить
Illi Vee
Illi Vee - 27.10.2018 18:46

Are you Ted or Edward?

Ответить
ashant kumar
ashant kumar - 24.08.2018 21:02

kya ms excel me koi bhi colam me me pi likhne per red calar kaise kre outometik

Ответить
Sunil Tantia
Sunil Tantia - 19.08.2018 11:30

Thank u sir..

Ответить
Rajeev Jayan
Rajeev Jayan - 18.05.2018 18:43

If I enter Los Angeles as state in one cell I need California as state in next cell please help me with any formal

Ответить
Youtuber Fin
Youtuber Fin - 05.05.2018 14:14

Good Knowledge Ehow

Ответить
Tao Li
Tao Li - 12.12.2017 17:49

不错。谢谢。很有用。

Ответить