Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
IF(COLUMN(8)-column(7)<0,RED(), If(COLUMN(8)-column(7)=0, White(),Green()))
Hi,
IF(COLUMN(8)-column(7)<0,RED(), If(COLUMN(8)-column(7)=0, White(),Green()))
Amazing thank you