Conditional formatting formula

Yamasaki450

Board Regular
Joined
Oct 22, 2021
Messages
69
Office Version
  1. 2021
Platform
  1. Windows
Hey everyone i need some help with formulas.

I need conditional formatting formula to highlight specific range of numbers in specific row.

I would like to highlight all numbers from (-4 to 65) in rows where number 3 is in column C.
So in this case all numbers from (-4 to 65) in range E4:T4 and E7:T7 are highlighted red.

See screenshot... i did this manually for row 4 and 7 which have number 3 in column C.
 

Attachments

  • 1.jpg
    1.jpg
    85.3 KB · Views: 21

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
You can try this:
Mr Excel Questions 75.xlsm
ABCDEFGH
1
229-40-3-61222-8-31
3179737787232861
457853902514898
5-178328763712258
685-4708160-16-374
7-38-32-4-39-3774983
8-4-5292-36843547
94161-486597495-32
10-27881956530-2083
113739094-25-33998
1264933-304397-48-42
13-1984357645866-31
148783-3-335937-3438
15-23-403-3940-14-3042
1693035542-385788
Sheet13
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D2:H16Expression=AND($C2=3,D2>=-4,D2<=65)textNO
A2:B16Expression=AND($C2=3,A2>=-4,A2<=65)textNO
 
Upvote 1
Solution
Great, happy to help. Best Wishes!
One more question.

Formula doesnt work if i change it from =AND($C2=3,D2>=-4,D2<=65) to =AND($C2=3,D2>=-4,D2<=-65) So highlight numbers from -4 to -65

Any idea how to fix this?
 
Upvote 0
You are welcome. Thanks for the confirmation. :)
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

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