Conditional Formatting in VBA

[cmrluvitlevit]

Conditional Formatting in VBA
I need some help with a VBA code. I need to create a fourth format in VBA to format the cells based on a fourth condition

Currently I have a couple of cell ranges that are using the three conditional formats. The conditions are as follows:
1) If the task is current - no conditional format
2) If the task is complete, the cell is green
3) If it is getting close the cell is yellow
4) If it is late it is red.

5) Need help -- Need the font color to be white, when cell equals "#NA"

In order for the chart to work, the tasks that are not assigned need to have #NA and not "". I would like to the #NA to appear blank by using the white text. need to use a fourth format that will turn the font color of a cell white (make it appear to be null) when it shows the #NA result. The only way to do this is through VDA code.

Can someone help me put together a code that will add the fourth condition to the ranges below?

The ranges are as follows:

D55:N55
D66:N66
D71:H71
J71:N71
D81:N81