Excel conditional formatting
Closed
hredding
Posts
3
Registration date
Tuesday May 30, 2017
Status
Member
Last seen
May 30, 2017
-
May 30, 2017 at 02:47 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 31, 2017 at 09:28 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 31, 2017 at 09:28 AM
Related:
- Excel conditional formatting
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- How to clear formatting in excel - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 30, 2017 at 03:40 PM
May 30, 2017 at 03:40 PM
hredding, Good afternoon.
Select A3 to apply the CF.
Menu Conditional Format
Using Formula
=ISTEXT(B3)
Select colour format as desired
OK
Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Select A3 to apply the CF.
Menu Conditional Format
Using Formula
=ISTEXT(B3)
Select colour format as desired
OK
Please, tell us if it worked as you desire.
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 30, 2017 at 04:33 PM
May 30, 2017 at 04:33 PM
hredding,
Try to use:
If you want to check a number 4 -->
=B3=4
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
If you want to check a number 4 -->
=B3=4
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
hredding
Posts
3
Registration date
Tuesday May 30, 2017
Status
Member
Last seen
May 30, 2017
May 30, 2017 at 04:54 PM
May 30, 2017 at 04:54 PM
Very helpful. Thank you. One more question...
What if I want a cell to display a number if another cell contains a specific word?
For example, if B3 contains the word "meets" then I want C3 to display a number 3
What if I want a cell to display a number if another cell contains a specific word?
For example, if B3 contains the word "meets" then I want C3 to display a number 3
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 31, 2017 at 09:28 AM
May 31, 2017 at 09:28 AM
hredding, Good morning.
This new question does not apply to the case of conditional formatting that deals only with aesthetic cell characteristics.
To do what you need, you must use the IF function.
Try to use:
C3 --> =IF(B3="meets", 3, "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
This new question does not apply to the case of conditional formatting that deals only with aesthetic cell characteristics.
To do what you need, you must use the IF function.
Try to use:
C3 --> =IF(B3="meets", 3, "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
May 30, 2017 at 03:54 PM