Format cell based on two values

[Orangeanorak]

Hi grateful if you can provide a formula for the following to format a cell based on two different values

=IF(G4 equals 6 or zero,"enter words","")

 

[Nine Zero]

=IF(OR(G4=6,G4=0),"enter words,"")

 

[Orangeanorak]

=IF(OR(G4=6,G4=0),"enter words,"")

Sorry I need to change this a bit - theres a third criteria

If Q2>1 and G4=6,G4=0,"enter words,""

 

[Orangeanorak]

Sorry I need to change this a bit - theres a third criteria

If Q2>1 and G4=6 or G4=0,"enter words,""

.

 

[Nine Zero]

sorry just now seeing this ...

yeah no problem just add it in the or statement

=IF(AND(Q2>1,OR(G4=6,G4=0)),"enter words,"")