J jk51 Member Apr 8, 2018 #1 Hi How to highlight cell on a range of cells of random values (A1:C10) not equal to zero (<>0) . For example if it 0.2, 2, -0.11 highlight fill in yellow cell if it 0, 0.0, 0.0000 do not highlight Thank you Best Mr Singh
Hi How to highlight cell on a range of cells of random values (A1:C10) not equal to zero (<>0) . For example if it 0.2, 2, -0.11 highlight fill in yellow cell if it 0, 0.0, 0.0000 do not highlight Thank you Best Mr Singh
P Peter Bartholomew Well-Known Member Apr 8, 2018 #4 If you were to select 'Use a formula' =A1 is itself sufficient to achieve what you require.