If formula based on cell colour

[TwistedGhost]

hello all,

i am trying to have my document strikethrough a line if a certain cell is black.

does anyone know the easiest way to do this i have tryed to find a if formula that would do it but have not been able to.

an example is below:

Supplier Supplier ID Method Email Contact Name PO # Printed Formatted Emailed Confirmed


i want the formula to check the PO# coloumn and if it is Black then strikthrough the whole line.

is there a way to do this?