Help on excel!

[IHatePopUpTents]

Is there anyway to use a code to make a cell turn green if it has a number

[TheSnowQueen]

Conditional formatting

[CyberMenStrual]

Can I hijack this thread and ask whether you can have a conditional formula to, for example, add up the contents of all cells coloured green?

[AnAdventureInCakeAndWine]

Not (AFAIK) for all cells coloured green, but yes to all cells with (for example) numbers less than 50 in -- look at the SUMIF function.

[IHatePopUpTents]

Fantastic, il have a look! It's for my partners work project! He did ict to gcse and I did it to alevel, therefore he thinks I should know these things!


If i get stuck il come back for the dummies guide to..!

[Beastofburden]

dont forget what colour you want 50 to be :)

For Cyber yes, sumif, or if you cant work that out, do a column that says =IF(ref

[widowerbutok]

Googled the question and found this:
www.extendoffice.com/documents/excel/849-excel-change-background-color-based-on-cell-value.html
Hope this helps

[Trills]

You can change the colour based on the value

But as far as I know you can't treat cells differently or do any calculations based on colour.

[widowerbutok]

Cyber, did the same for your question and found this (geeeesss its complicated)
www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html

[CyberMenStrual]

Thanks widowerbutok - I'll have fun playing with that this weekend [incredibly sad old fart emoticon]