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.
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.
Member for
17 years 8 monthsRE: Excell function to capture data from a cell of group
ANDREW , CAN I GET YOUR EMAIL ID .
SO THAT I CAN SEND YOU THE FILE .
RGERDA
SHIV
Member for
20 years 11 monthsRE: Excell function to capture data from a cell of group
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
Member for
18 years 6 monthsRE: Excell function to capture data from a cell of group
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.
Member for
17 years 8 monthsRE: Excell function to capture data from a cell of group
The Colour will be set manually .
and the value is to be calcualted based on the cell which are red in colour.
Shiv
Member for
20 years 6 monthsRE: Excell function to capture data from a cell of group
its impossible to use cell format as criteria in function SUMIF.
how you set the color of a cell? mannually or by conditional format.
Member for
18 years 6 monthsRE: Excell function to capture data from a cell of group
Click on a RED formatted cell and go Format Conditional Formatting. The criteria will be there!
Member for
17 years 8 monthsRE: Excell function to capture data from a cell of group
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
Member for
18 years 6 monthsRE: Excell function to capture data from a cell of group
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.