Excel 2011 Conditional Formating Icon Help

[TravelersLandscaping]

Okay, what I am trying to accomplish is, instead of having "X"'s in the Done box(B) I would like to have the Green Check Icon there when a completion date is in Row F. If there Isn't a date added I would like there to be the yellow exclamation point. Any Ideas?

[teylyn]

Hello,

you can put this formula into B6 and copy down

=IF(ISNUMBER(F6),1,0)

Then apply icon set formatting to the cells. Edit the conditional format, set the type to Number instead of Percent, enter the values 1 and 0 in the value boxes for the tick and exclamation mark, and then tick the box for "Show Icon only"

see attached

[TravelersLandscaping]

Hello,

you can put this formula into B6 and copy down

=IF(ISNUMBER(F6),1,0)

Then apply icon set formatting to the cells. Edit the conditional format, set the type to Number instead of Percent, enter the values 1 and 0 in the value boxes for the tick and exclamation mark, and then tick the box for "Show Icon only"

see attached

Thanks for the help but please bare with me, where do I put the formula in at?

[teylyn]

you can put this formula into B6 and copy down

Did you read this?

[TravelersLandscaping]

I see, Thank you. What If I would like to do the same for the paid box? If there is an amount I would like a green check, No amount yellow exclamation mark, and if it says "No Pay" a red X?

[teylyn]

If you want to apply icon sets to a cell, then the cell will need to hold the value. Icon sets cannot refer to another cell.

You can create a helper column with the cell values, use icon sets on that helper column and position this column in the desired location.

You can use formatting of cells (borders, fill, etc) to make two columns appear as one.

cheers,