You can use conditional formatting with custom formula to set the condition for a range.
From menu Format -> Conditional formatting
, set these options and enter =IF($D1<$C1/2,TRUE)
as custom formula. Also, pick your desired color from Formatting Style -> Text Color
option.
Sample data:
References:
Conditional Formatting
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…