INSERT OBJECT USING (IF(AND

  • Thread starter Thread starter RBOWMAN
  • Start date Start date
R

RBOWMAN

I would like to use the (if(and function to compare a
condition and if it is true I want to insert a red flag
in the cell next to it. 1) What is the (if(and formula
for inserting an object and 2) any ideas on finding a red
flag to insert?
 
Hi

Have a look at the graphics in Wingdings fonts. You may find something you
like there. As for the formula, post back with what you have and what you
want . . .

Andy.
 
RBOWMAN
You cannot use a formula to insert an object. If yoiu can find a wingding you like as Andy suggested the you can set the font to red and use a standard IF statment

=IF(condition,true,false

of if you need the AND then

=IF(AND(condition1,condition2),true,false

Another option might be to use Format>Conditional_Formatting. With this you could change the cell background or font color to red and highlight the actual cell which contains the data

Good Luck
Mark Graesse
(e-mail address removed)


----- RBOWMAN wrote: ----

I would like to use the (if(and function to compare a
condition and if it is true I want to insert a red flag
in the cell next to it. 1) What is the (if(and formula
for inserting an object and 2) any ideas on finding a red
flag to insert
 
-----Original Message-----
Hi

Have a look at the graphics in Wingdings fonts. You may find something you
like there. As for the formula, post back with what you have and what you
want . . .

Andy.




.
As for the formula - lets make it real simple
Click to expand...
if(a1>a2,inset red flag,"").

I am not fimiliar with wingdings, where do I find them?
I have look at the autoshapes, but have not found
anything.

Thanks for your help.
 
Change the font in that particular cell. On one of your toolbars you should
see 'Arial' or some similar font name. Click on the arrow alongside and
select Wingdings, or Wingdings2, or Wingdings3

Andy.
 
Back
Top