EXCEL 2000 FORMULA / FORMATS

  TAMPICO 18:11 28 Feb 04
Locked

Is it possible to get excel, to multiply by one value, if a certain cell is one colour and a different value if it is another colour.

  VoG II 18:20 28 Feb 04

If the cell colours have been set using Conditional Formatting then you could achieve this using the equivalent conditions in an IF statement in the formula that you are using.

If not, you need to use VBA coding as there are no worksheet functions to do this. Have read of click here and post back if you need more help.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…