Hi Mike,
Select cell H1, goto top menu's > format > conditional format.
Condition 1:
formula is: G1=1 apply desired format.
Condition 2:
formula is: G1=2 apply desired format.
Condition 3:
formula is: G1=3 apply desired format.
Click OK.
Drag cell H1 down.
If you already have data in column H, select "format only" from the small square that appears when you are donw dragging.
Best regards,
Trowa
Dragging down the H1 cell with the formula is not helping me replicate the same in the dragged down cells. Please help
Alleluia! Working on a =if($G1>$H1,true,false) and it works great.
So, in conditional format, with G5 selected, I put G7<>"", then format red and bold
Any suggestions?