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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 6, 2017 at 08:16 AM
Related:
- How do I use conditional formatting in Excel
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- How to clear formatting in excel - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 6, 2017 at 08:16 AM
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
Glad to have helped you.
Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
May 5, 2017 at 06:33 PM