S
Sudip_inn
Guest
suppose i have value from cell A1 to A11
now i want to create a range from A1 to A10 and assign formula to this range A1:A10. in the formula how to write instruction like that if A1 value is greater than cell A11 then A1 cell color will be green and if A1 value is less than cell A11 then A1 cell color will be red.
the same way A2 to A10 same this will be carried forward.
but i want to assign some formula to range instead of each cell from A1 to A10. how it will be possible with conditional formatting with formula using EPPlus. i stuck here badly because i have little knowledge in excel. so please some one help me to complete the code. so please help me with code example. thanks
Continue reading...
now i want to create a range from A1 to A10 and assign formula to this range A1:A10. in the formula how to write instruction like that if A1 value is greater than cell A11 then A1 cell color will be green and if A1 value is less than cell A11 then A1 cell color will be red.
the same way A2 to A10 same this will be carried forward.
but i want to assign some formula to range instead of each cell from A1 to A10. how it will be possible with conditional formatting with formula using EPPlus. i stuck here badly because i have little knowledge in excel. so please some one help me to complete the code. so please help me with code example. thanks
Continue reading...