Conditional Formatting Question for when adjacent cell exceeds certain threshold

R

Rhothgar

Board Regular
Joined
Sep 24, 2013
Messages
51
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
Good evening,

Hope you are all well.

I have a spreadsheet which I cannot post as my Mr Excel BB XL2BB is not working.

So I have a column BV which I am typing information into. I have set up a column BW with "=LEN(BVn)" entered into it.

I would like either BV or BW Column (it doesn't matter which) to take on a fill colour when the length of BV exceed 155 characters. Is this possible please and what would the code be for it?

And if not, I am happy to create another column adjacent which just takes on the fill if necessary. I just need a visual indicator.

Thank you in advance.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sort by date Sort by votes
FALSE ALARM!

Managed to crack it. Only took me 31 minutes...

I'm absolutely rubbish with conditional formatting.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
conditional formatting a cell when it is within a certain time bracket
Replies
5
Views
150
Mr Marvin
M
J
  • Question
Conditional formatting based on value of another cell
Replies
3
Views
252
etaf
etaf
K
  • Solved
conditional formatting of cell and adjacent cells
Replies
6
Views
252
kristian97
K
G
  • Solved
Conditional formatting from multiple cell data to multiple cells when data is selected from a drop down menu
Replies
8
Views
809
etaf
etaf
O
  • Question
Excel/VBA to conditionally send emails per schedule
Replies
0
Views
706
OC2PS
O

Forum statistics

Threads
1,215,123
Messages
6,123,183
Members
449,090
Latest member
bes000

Share this page

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