Excel Magic Trick #394: IF Function and Conditional Formatting

[miiihaaas]

Thanks man!!!

[ExcelIsFun]

You are welcome!

[HeySL87]

hey thanks for sharing thise tips!

I've some thing to ask.

I am in the share market and I have a huge spread sheet database(chart) of morethan 500 comapnies and everyday prices of them for more than 2 years.

I want to make each cell turn to red IF the Privious day's price is higher, or green IF privious day's price is lower or yellow IF the both prices are equal. and I want to apply it for the whole 2 years.

I tried every thing I know but nothing workout. :S

hope you can help me ! thanks!!

[ExcelIsFun]

Try this video and see if it helps:

Mr Excel & excelisfun Trick 14: Trending Up Down Arrows

[HeySL87]

@ExcelIsFun thanks man !!! I really appreciate !! thumbs up from me !!!

[ExcelIsFun]

You are welcome!

[baliwag]

hi! i have a question. what if i want to automatically highlight the entire row when a cell is "equal" to a certain text.

for example:

i have misc. values for cell A1 TO E1 (mix text, dates and numbers) and on

F1 i input a text "WITH RESULTS", and i want to highlight the entire row with "WITH RESULTS" text in FCOLUMN ONLY.. what should be the right formula ?

thanks

[ExcelIsFun]

Try this video:

Excel Magic Trick #6: Conditional Formatting for a Row

[khorse69]

Hi there is it possible you could do a video on how to use fuzzyvlookup please??

[ExcelIsFun]

Search for this video title:

Excel Magic Trick 323: Partial Text VLOOKUP

[tatsf226]

how to make conditional formatting dialogue box come out?

[ExcelIsFun]

In Excel 2003: Formatting menu, Conditional Formatting

In Excel 2007: Home ribbon, Styles group, Conditional Formatting

Keyboard shortcut for all versions: Alt + O + D

[Mynotoar]

Very interesting :). And if, for some reason, the IF formula didn't work, you could then add a second condition whereby a cell that doesn't have "Warning" in it or doesn't equate to B2<E$2, then the cell would remain blank :P.

Interesting!

[ExcelIsFun]

I am glad that you liked it!

I did not understand what you said in the second part of your post, could you re-state what you said?

[mercy2mercy]

great, thx

[ExcelIsFun]

You are welcome!