How do I use conditional formatting in Excel

Solved/Closed
newbie - Updated on Jun 16, 2017 at 02:29 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 6, 2017 at 08:16 AM
Hello, i am new on this excel things but, i need it for work..
so, here it goes.

is it possible if it like this ?

example : A B C

if A contain "spesific text" and B contains any number then C call for B value
both condition have to be met or leave it empty.

not sure if my english is right. hope someone understand and willing to help.
thanks before.

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 5, 2017 at 05:11 PM
newbie, Good evening.

Try to use:

C1 --> =IF(AND(A1="DESIRED TEXT",ISNUMBER(B1)),B1,"")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
thanks alot... thats exactly what i need...
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 6, 2017 at 08:16 AM
Thanks for the feedback.
Glad to have helped you.

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