Excel Magic Trick 1345: Conditionally Format Product Name for No Items Entered in Row (4 Methods)

Download Files:

Start File and Finished File:

See how to use a Logical Formula and Conditional Formatting to highlight Product Name when no items are entered in the row. See 4 methods:
1. (00:11) Introduction to Using Logical Formulas to Apply Conditional Formatting.
2. (01:30) Method 1: COUNTA function with Equal Sign Comparative Operator. COUNTA function counts cells that are not empty.
3. (02:54) Method 2: COUNTA and NOT function. NOT function converts TRUE to FALSE and FALSE to TRUE.
4. (03:52) Method 3: COUNT function with Equal Sign Comparative Operator. COUNT function counts cells that contain numbers.
5. (04:37) Method 4: SUM function with Equal Sign Comparative Operator. SUM function adds numbers and will ignore Text Values.
6. (04:58) Conditional Formatting Dialog Box for Logical Formulas. “Use a formula to determine which cells to format”. “Format values where this formula is true”.
7. (06:18) Conclusion

[krismaly]

I enjoyed watching this video and recommend others.

I tried along with host and it worked fine.

Thanks for educating the community and appreciate your volunteership.

God Bless you for teaching and other good things you do

Thanks a lot

[MohamedAlyCLAY]

nice as always :)
first time to know about not function

[DevaP]

Hi Michael,

Thank you for all the training videos on excel.

I have a few queries regarding data model in excel 2013. Where can i post my queries?

[forzaalgiers]

Forgive me asking Mr Girvin, isn't Methode 3 and Method 4 Not quiet right if we look at the Product 6 ( 2 Trues)

[XLarium]

Method 4 fails if there are negative numbers or the number 0.