E
et
Can I use conditional formating to make a cell crossed by a line when it is
empty.
¡@
Thanks for your help.
Eling
empty.
¡@
Thanks for your help.
Eling
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
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
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
D
David McRitchie
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.
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.
E
et
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.
as I can. Please excuse me for the ambiguity of the question as English is
not my mother tongue.
David McRitchie said: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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
et said:Can I use conditional formatting to make a cell crossed by a line when it
is
empty.
¡@
Thanks for your help.
Eling