I need to set up color coding for five different conditions - can you help me?
if A1 cell value is greater than or equal to 6 then color yellow
if A1 cell value is between 5 and 6 then color silver
if A1 cell value is between 4 and 5 then color blue
if A1 cell value is less than 4 then color red
if A1 cell value has no value (entered) then color cyan

can we do this with conditional formatting or do we need VB for this? if vb
is needed can i get some idea how to create the code...

i am not good at coding...please help me....