Excel Magic Trick #394: IF Function and Conditional Formatting

See how to use the IF function and Conditional Formatting to show the words Warning with a red format when a cell value is too low. Learn about how the Logical_test in the IF function relates to the TRUE / FALSE formula in the Conditional Formatting dialog box.

Category:

Science & Technology

Tags:

• Excel
• IF
• function
• Conditional
• formatting
• TRUE
• FALSE
• formulas
• cell
• value
• is
• too
• low
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Commuity
• College

[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!

[ExcelIsFun]

Try this video:

Excel Magic Trick #6: Conditional Formatting for a Row

[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]

Search for this video title:

Excel Magic Trick 323: Partial Text VLOOKUP

[khorse69]

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