Excell function to capture data from a cell of group
Forum Sponsor
Top Posters
Haque Nawaz
10 posts
EViLL1
1 posts
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
ANDREW , CAN I GET YOUR EMAIL ID .
SO THAT I CAN SEND YOU THE FILE .
RGERDA
SHIV
Use custom function in VBA for this purpose. If you are not familiar with VBA just send to me excel file and Ill do it. Regards,
Andrew
If you set the colour manually then you cant do it. If you make the conditional format for example, so 1 makes the cell red, then you could do a SUMIF or COUNTIF with 1 as the criteria.
The Colour will be set manually .
and the value is to be calcualted based on the cell which are red in colour.
Shiv
its impossible to use cell format as criteria in function SUMIF.
how you set the color of a cell? mannually or by conditional format.
Click on a RED formatted cell and go Format Conditional Formatting. The criteria will be there!
Oliver thanks for your good try .
We need the condition format as a criteria .
And thats not excepting.
Sumif[A2:A8]"criteria" range.
In the criteria we need to find if a cell is red in colour then we are going to sum the range of values.
But i think we are near to the answer.
Someone there to help us plz.
Regards
Shiv Rao
Conditional formatting uses a statement to decide if the cell should be RED. Look at the conditional format of a RED cell and use it as part of a SUMIF function.