Including cells that are highlighted in a formula

R

Robin

I have a strange requirement maybe, but I do a budget spreadsheet on which I
highlight items that have cleared my checking account. I would like to be
able to write a formula that sums only the cells that are highlighted a
certain color. Is this possible?
 
R

Robin

let me clear this up a little. I don't really mean "highlighted" as in I
highlighted them with a mouse. What I mean is formatted with a fill color.
sorry for the confusion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert shading to highlighting for specific colors 8
Add value of (1) to a selected cell or cells 2
Highlighting cells if a value is obtained 4
Excel does not accept text format! 0
Changing the color of highlighted cells 1
Summary based on highlighted cells 4
can conditional formatting varry the area it highlights based on c 3
Add numbers if cell fill is a certain color; How To? 5

Top