Conditional Formatting issue

[RobMazaheri]

using this formula  IF(COLUMN(8)-column(7)<0,RED(),Green())

what I need is when the column is 0 then make it white 

can anyone help with this please 

[Aurelien_Martinez · Accepted solution]

Hi,

IF(COLUMN(8)-column(7)<0,RED(), If(COLUMN(8)-column(7)=0, White(),Green()))

[RobMazaheri]

Amazing thank you