I have numeric values in cells A1:J30.
Some cells are conditionally formatted to be filled red, some yellow, etc etc etc.
Is there a formula that I can use that will sum only the values found in red-filled cells for a given row.
I believe it can be done by vba code, but I'd prefer to use a formula if at all possible.
If a formula is not possible, can someone please let me know what code might need to be used.
Ta in advance,
Chris
Some cells are conditionally formatted to be filled red, some yellow, etc etc etc.
Is there a formula that I can use that will sum only the values found in red-filled cells for a given row.
I believe it can be done by vba code, but I'd prefer to use a formula if at all possible.
If a formula is not possible, can someone please let me know what code might need to be used.
Ta in advance,
Chris