Excel Guru's

[richy22]

After a bit of assitance with excel and formula's!

Been years since I have anything in Excel and just getting myself in a right kerfuffle!

Basically Im trying to get a Cell to show ,Automatically red if it is below 80% and Green if its anything above 80%

Im trying to do it via an IF statement I.e =IF(S85 <=80 ... then Im stuck! Bloody pain in the arse! What am i missing to turn them red if <80 and green if >80?

Anyone give me some pointers?

 

[JoedotwasT5phy]

hello mate - do you know how to use conditional formatting? - it's easy as s**t

 

[richy22]

OOOO I "think" I have solved this myself!!

Conditional Formatting FTW!!

 

[Rhino172]

conditial formating is the way forward...

highlight the cells you want it to work on...Format - Conditional formating then it's pretty self explanatory

 

[richy22]

hello mate - do you know how to use conditional formatting? - it's easy as s**t

Just came across that actually! Piece of cake... Highlight cells and say if those cells =<80 turn red... If they are>80 turn green!

Just tested it and it works!

 

[JoedotwasT5phy]

Sweet - Drop me PM or summit if you have any more probs i know my excel shiz y'all

 

[Rhino172]

what if it actualy equals 80% tho

 

[richy22]

what if it actualy equals 80% tho

Ahh yeah thats going to be the issue!

 

[JoedotwasT5phy]

Think you'll find theres a field for greater than or equal to

 

[richy22]

Condition 1

Cell Value Is Less than or equal to 0.59 = Red

Condition 2

Cell Value is Greater than or equal to 0.6 = Green

Works as well! My god why didnt they teach me that on the CLAIT course rather than all this IF b****cks!!