Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
55
Views
Topic starter
I followed your advice and I post my issue on forum. I am a beginner with conditional formatting.
IF A1 contains the string "xc", then C1 = B1 + 5.
Of course, it must be done for all cells in column.
Thank you for help.
Posted : 08/05/2021 5:16 am
Salut Bogdan,
If you need to put a value in column C, that's not really a conditional formatting, it's a simple formula.
Try this formula in C1:
=IF(ISNUMBER(SEARCH("xc",A1)),B1+5,B1)
It will return B1 if the string is not found in A1.
Posted : 08/05/2021 2:49 pm
Topic starter
The solution works perfectly. Thank you very much.
Posted : 08/05/2021 6:00 pm