SRL Archive - News and General

Hard "if"'s Excel


sm321

2012-04-25 16:50:03

I have no found out how to do it, it's "conditional formatting".

The Killer

2012-04-25 17:28:29

sigh i think i did this a year or two ago, might of been in access. shame i cant remember sorry

The Killer

2012-04-25 17:33:14

try lookign at this : http://spreadsheets.about.com/od/iffunctions/ss/2010-08-03-Excel-2007-If-Function-Step-By-Step-Tutorial.htm

sm321

2012-04-26 03:24:43

From: cookies1
sigh i think i did this a year or two ago, might of been in access. shame i cant remember sorry


From: cookies1
try lookign at this : http://spreadsheets.about.com/od/iffunctions/ss/2010-08-03-Excel-2007-If-Function-Step-By-Step-Tutorial.htm


I know how to make if functions, but I just need to know how to add colours. Thankyou for the replies :)

Ixilisi

2012-04-26 04:36:35

Use Conditional Formatting either in the main toolbar if on excel 2011 or in a menu for olderversions:

http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

sm321

2012-04-26 04:42:33

From: Ixilisi
Use Conditional Formatting either in the main toolbar if on excel 2011 or in a menu for olderversions:

http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel


I just found that out infact, thankyou :)