C
ChristinaC
I am trying to do the following:
1. In cell H14, if the cell is blank, turn blue.
2. In cell H14, if the cell has a date less than or equal to another cell,
turn green.
3. In Cell H14, if the cell has a date greater than another cell, turn
orange.
4. If NA is placed in the cell, revert to no format.
I have managed the first three, but cannot get the fourth one to work. What
formulas should I be putting in Each condition?
1. In cell H14, if the cell is blank, turn blue.
2. In cell H14, if the cell has a date less than or equal to another cell,
turn green.
3. In Cell H14, if the cell has a date greater than another cell, turn
orange.
4. If NA is placed in the cell, revert to no format.
I have managed the first three, but cannot get the fourth one to work. What
formulas should I be putting in Each condition?