Icon sets based on columns with dates giving me grief

Trish_Hopkins 

So far, I understand you are trying to use icon sets in a spreadsheet to visually represent the status of tasks based on dates in columns C and D.

If this is correct...

You can use conditional formatting with a formula to achieve your desired result.

Here’s how you can do it:

1. Select the cells in the Status column that you want to apply the formatting to.
2. On the Home tab, click Conditional Formatting > New Rule.
3. In the New Formatting Rule dialog box, select “Use a formula to determine which cells to format”.
4. In the formula field, enter a formula that returns TRUE or FALSE based on the values in columns C and D. For example, to display a yellow icon when there is a date in column C but not in column D, you could use the formula =AND(ISNUMBER(C1),NOT(ISNUMBER(D1))).
5. Click Format and select the yellow icon from the Icon Sets.
6. Repeat steps 2-5 for the other two icon sets (red and green), using appropriate formulas for each.

If it's not what was wanted, please include the following info to help others answer your question:

Welcome to your Excel discussion space!

I hope this helps!