G Guest Nov 8, 2007 #1 What is the syntax to write a conditional statement to color a group of cells red if larger than 50, yellow if between 50 & 20, and green if less than 20?
What is the syntax to write a conditional statement to color a group of cells red if larger than 50, yellow if between 50 & 20, and green if less than 20?
G Guest Nov 8, 2007 #3 Hi, use conditional formatting. Select your group of cells then:- Format|Conditional format select cell value is|less than = to 20 and select a colour Click add for your second and third conditions. Mike
Hi, use conditional formatting. Select your group of cells then:- Format|Conditional format select cell value is|less than = to 20 and select a colour Click add for your second and third conditions. Mike