Conditional Format Formula meeting Multiple Criteria

ozbeachbum

Board Regular
Joined
Jun 3, 2015
Messages
246
Office Version
  1. 2021
Platform
  1. Windows
Using Conditional Formatting in Colum B
Looking for a formula that will indicate if any
Items in Columns F L S are not blank and Qty equals Zero.

250110 and or pantry.xlsx
BCDEFGHIJKLMNOPQRST
6Using Conditional Formatting in Colum B
7Looking for a formula that will indicate if any
8Items in Columns F L S are not blank and Qty equals Zero.
9
10
11ResultItemQtyItemQtyItemQty
12
13
14TEST 1-101TEST 2-106TEST 3-106
15TEST 1-204TEST 2-207TEST 3-202
16TEST 1-300TEST 2-301TEST 3-303
17TEST 2-400TEST 3-400
18TEST 2-500
19TEST 2-609
20TEST 2-706
21TEST 2-800
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Template
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
like this ??

Excel Formula:
=OR(($F7<>"")*($H7=0),($L7<>"")*($N7=0),($R7<>"")*($T7=0))


1736498769939.png
 
Upvote 0
Solution
Thanks so much, works perfectly.
Could you help with my education and explain what the * stands for in this instance.
 
Upvote 0

Forum statistics

Threads
1,225,735
Messages
6,186,716
Members
453,369
Latest member
positivemind

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top