I would like the cell be filled with green colour if another cell value is 3, how to write the fomula ? eg, cell A1 will be filled with green colour if cell A2=3 ? Or A1 wording will change to red colour if A2=3 ?
Thks in advance.