Help on excel!

(10 Posts)
IHatePopUpTents Fri 17-Jan-14 12:56:00

Is there anyway to use a code to make a cell turn green if it has a number <50 in and red if it's >50?

If so can someone please tell me!!

TheSnowQueen Fri 17-Jan-14 14:54:22

Conditional formatting

CyberMenStrual Fri 17-Jan-14 14:57:19

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 Fri 17-Jan-14 15:04:12

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 Fri 17-Jan-14 15:28:07

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 Fri 17-Jan-14 15:34:01

dont forget what colour you want 50 to be smile

For Cyber yes, sumif, or if you cant work that out, do a column that says =IF(ref<50,0,1) and then multiply that result by the original numbers above and below 50, so numbers below 50 become zero. then sum that column. you can hide the two columns that get you there.

widowerbutok Fri 17-Jan-14 16:44:01
Trills Fri 17-Jan-14 16:45:17

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 Fri 17-Jan-14 16:50:43

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 Fri 17-Jan-14 17:06:05

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

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now