I can't find where it is or how to put a yellow exclamation triangle in a cell,
it is a excel build in yellow triangle with a exclamation in it, need to use it if a
cell needs a attantion.
Thx for any help
yellow exclamation triangle
-
-
-
Re: yellow exclamation triangle
Do you mean Smart Tags?
-
Re: yellow exclamation triangle
I guess thats it, but they hoover on mous-over and i need it in to stay in a cell.
-
Re: yellow exclamation triangle
Sure You don't mean comment indicator (they are red thou) Top right of the cell
Background checking is a green triangle top left of cell
jiuk -
Re: yellow exclamation triangle
I think you are referring to the Trace Error tag that appears when a formula needs attention. From Excel Help on Smart tags
Quote
The Trace Error button appears next to the cell in which a formula error occurs, and a green triangle appears in the upper-left of the cell. When you click the arrow next to Trace Error , a list appears to give you options for error checking. -
Re: yellow exclamation triangle
I mean one like below but not as a picture but as a excel object.
-
Re: yellow exclamation triangle
I've never sen that in a cell, only what I have mentioned. Have you got an example?
-
Re: yellow exclamation triangle
You can get that warning symbol as part of data validation.
It's not displayed in the cell but will appear if an incorrect value is entered in a cell. -
Re: yellow exclamation triangle
Quote from xequtorI mean one like below but not as a picture but as a excel object.
That image does not show up in a cell as far as i know. However is a warning icon / symbol - test the cell You think it might be linked to ie change from a value to text and see if it pops up or disappearsLook at Data Validation under to Tools Menu - setting live there that might be tracking cell(s) and warning given as a results
Other than that nothing comes to mind sorry buddy - i did try
jiuk
-
Re: yellow exclamation triangle
I think I'll use a shape for that,see in link below.
Thx.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!