Hi all I want to Add conditional formatting to sheets using advanced excel, So I am not very familiar with the conditional formatting and what should be added in the inputs of Conditional formatting add rule inputs. I want to check the cell value if it is 1 or 0 and if it is "1" I need to add/fill in background color and also change the font color
Hi,With the following settings, the background is black and the text color is white when the cell is 1.I hope you will find it useful.