exclude cells from calculation if custom format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have column of calculated figures, some of which have manually set custom
format to a different colour. How can I NOT include these when doing further
calculations, eg. am searching array using vlookup and if statments but if
result is cell with custom colour want to give warning message.
 
if you are just using worksheet formulas, then the have no cognizance of cell
color. (although you could write a UDF in VBA to return the value of the
color index).

If you are using code, just examine the cell for its interior.colorindex
 
Thanks Tom,
I was hoping that there was a way to do it on the worksheet, but I guess to
have to try to put the calculations into code.
 

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

custom function - finding cell address 4
single cell time entry as time - time; Ever seen this? 12
function to re-calculate when cell format (colour) changes 1
Conditional formatting with vba 3
Time Calculations Help 4
Exclude cell from average calculation 6
conditional format fails when copied 1
Changing a cell colour if target not met. 4

Back
Top