Highline Excel Class 21: Conditional Formatting 12 Examples

See how to add conditional formatting for:
1)Data Bars to show relative size
2)Icons to show relative size
3)Highlight values within 1 standard deviation
4)Highlight MIN in column with a TRUE FALSE formula
5)Highlight MAX in column with a TRUE FALSE formula
6)Highlight two largest values with a TRUE FALSE formula
7)Highlight a of values with a TRUE FALSE formula
8)Highlight a column of values with a TRUE FALSE formula
9)Highlight an intersection with a TRUE FALSE formula
10)Learn about Stop If True
11)Learn about the order of the TRUE FALSE formulas
12)Apply more than 1 conditional formatting
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Education

Tags:

• Excel
• Conditional
• Formatting
• Format
• TRUE
• FALSE
• formulas
• more
• than
• one
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• Coll

[shootmanager1]

Hi,

Can you use colour formating to use the IF function. I am trying to sort sales figures into confirmed and provisional sales and want to colour code the amounts.

[ExcelIsFun]

I do not understand your question. You might try posting your question to THE best Excel question site:

mrexcel[dot]com/forum

This site is great because you can have a dialog to get you an Excel solution (YouTube is not very good for dialogs and posting pictures of Excel spreadsheets).

[SoldierOfMahdi123]

Sorry but when you hit F9 I couldn't understand that what happened when you pressed F9?

[ExcelIsFun]

If you have part of a formula highlighted and you hit F9, it evaluates formula (convert formula to hard coded formula result). However, this trick is only to see what the formula part evaluates, you usually want to immediately hit Ctrl + Z to undo. An example, A1:A3 contain 2,2,2, if you highlight the formula =SUM(A1:A3), it would show the formula answer 6; but immediately undo to get back to =SUM(A1:A3).

[ExcelIsFun]

Yes, it is possible, but it is not possible in the comment section to communicate on a topic like this. This is THE best site for asking Excel questions:

mrexcel[dot]com/forum

Please post to this site and then send me the link (excelisfun at gmail) and I will post an answer for you.

[tmkm130]

@ExcelIsFun You truly are a great teacher. I hope you are gathering a collection of these videos so that they never disappear from YouTube! I thought this was a great video. Unfortunately, it did not answer my question. I would like to know if there is a way that conditional formatting can be applied to a large list of data that contains values that match another list (range)?

[ExcelIsFun]

I do not know. Try this site:

mrexcel..com/forum

[acemaj]

Good to know but the pattern I am looking for is more sporadic. In other words, my first 12 rows might be $5000, then 12 - 46 $8000, then 47-60 $16,000. However, this pattern might change for a different spreadsheet. Is there a word to automate formatting with alternating colors this way? It's pretty much the same as conditional formatting, but I want alternating colors instead of a "rainbow pattern"

Thanks!

[ExcelIsFun]

Try this video title:

Excel Magic Trick 685: Conditional Format For Alternative Rows

But then use the columns function instead of rows.

[acemaj]

How do I conditional format so that I can alternating color patterns for a data set whenever it changes in value?  In other words, I want a rule that makes a column with the first set of values white, then next set of values that are the same blue, then white again, etc. Thanks!