O with a horizontal bar
Solved
JCB40
Posted messages
3051
Registration date
Status
Membre
Last intervention
-
JCB40 Posted messages 3051 Registration date Status Membre Last intervention -
JCB40 Posted messages 3051 Registration date Status Membre Last intervention -
Hello,
I would like to know if it is possible to create a horizontally crossed O in Excel.
Thank you for your help.
Best regards
Configuration: Windows / Firefox 69.0
I would like to know if it is possible to create a horizontally crossed O in Excel.
Thank you for your help.
Best regards
Configuration: Windows / Firefox 69.0
3 réponses
Hello
if you want an occasional 0 under certain conditions, you can use conditional formatting with font style and check "strikethrough"
for example, to have a strikethrough 0 in B1 if A1=1 and B1=0:
conditional formatting formula:
=AND(A1=1,B1=0)
and format: font / strikethrough
and in any case, a strikethrough font cell format will give you a strikethrough display
best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!
if you want an occasional 0 under certain conditions, you can use conditional formatting with font style and check "strikethrough"
for example, to have a strikethrough 0 in B1 if A1=1 and B1=0:
conditional formatting formula:
=AND(A1=1,B1=0)
and format: font / strikethrough
and in any case, a strikethrough font cell format will give you a strikethrough display
best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you!