Conditional Formatting Assistance Needed

ULFireTester

New Member
Joined
Oct 22, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi ya'll,
I'm needing help with some conditional formatting.

Here's what I'm needing in the same cell:
If a cell from another tab (Info!J23) is less than 3000, highlight the cell if the data entered into it is outside the range of 142.5 to 157.5.
If the same cell from above (Info!J23) is 3000 or higher, highlight the cell if the data entered into it is outside the range of 95 to 105.

The cell from the other tab is: Info!J23

I know how to manipulate how the cell gets highlighted (color, text, border, etc.), I just need help with the formula.
For reference, attached is a picture of the note I've put on the cell that pops up when you hover it.

Thanks in advance.
 

Attachments

  • Conditional Formatting Note.jpg
    Conditional Formatting Note.jpg
    12.3 KB · Views: 4

Some videos you may like

Excel Facts

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

McGuilliam

New Member
Joined
Oct 23, 2020
Messages
21
Office Version
  1. 2016
Platform
  1. Windows
Hi

Give this formula a try:

Excel Formula:
=if('Info!$J$23<3000;or(A1<142,5;A1>157,5);or(A1<95;A1>105))

Of course you should adjust "A1" to the cell you need the conditional format to be in.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,364
Messages
5,595,722
Members
414,013
Latest member
tnobbs

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
Top