Hi,
I have a table in a worksheet with refs from other tables in the workbook because it has references when I apply conditional formatting to the table anything that is >= 0 the cell is Green but the table is on week numbers and I am only to week 13 an it has 52 weeks in table. As from wk 13 it's all green because the cells have 0 in them. All I want is to apply the conditional formatting to the cell that has actual real values and 0 in them.
Any ideas
Eg
Weeks no. 1. 2. 3... 13. 14 15
Figures. 52. -3. 24. -56. 0. 0.
Cell color. G. R. G. R. G. G
I have a table in a worksheet with refs from other tables in the workbook because it has references when I apply conditional formatting to the table anything that is >= 0 the cell is Green but the table is on week numbers and I am only to week 13 an it has 52 weeks in table. As from wk 13 it's all green because the cells have 0 in them. All I want is to apply the conditional formatting to the cell that has actual real values and 0 in them.
Any ideas
Eg
Weeks no. 1. 2. 3... 13. 14 15
Figures. 52. -3. 24. -56. 0. 0.
Cell color. G. R. G. R. G. G
