Add "/" when the cell is empty

  • Thread starter Thread starter et
  • Start date Start date
E

et

Can I use conditional formating to make a cell crossed by a line when it is
empty.

¡@



Thanks for your help.

Eling
 
The diagonal border isn't one of the CF choices.

You could use VBA, though. Put this in the worksheet code module
(right-click on the worksheet tab and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("A10")) Is Nothing Then
With Range("A10")
If IsEmpty(.Value) Then
With .Borders(xlDiagonalUp)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Else
.Borders(xlDiagonalUp).LineStyle = xlNone
End If
End With
End If
End Sub
 
Despite the ambiguity of the question, I think the answer is no.
Also the subject does not summarize the question as it was not
mentioned in the question which also leaves one to wonder if
you mean an image or a character.

You cannot place an image onto a sheet with conditional formatting.
You cannot place a character into a cell with conditional formatting.
You cannot test for the presence of an image over a cell with C.F.
(you would have to use code to determine corners of an image)

I guess J.E. came up with another possibility of the question,
diagonal borders, and a solution if that is what is meant.
 
Thanks for your advice. I will try my best to explain my question as clear
as I can. Please excuse me for the ambiguity of the question as English is
not my mother tongue.
 
Back
Top