Excel Conditional Formatting?

B

Ben Blackmore

Hi,

I have our company IP address range in excel format. I want to do
conditional formatting so I clearly see the different scopes. If I do
conditional formatting so that 'If Cell', 'Is Between' '192.168.61.0' &
'192.168.61.255' format colour as Red. Only a few of the IPs actually go
red! i.e. 192.168.61.25 is red, but 192.168.61.27 isn't!
Can anyone see why?
Is this a bug?

Cheers

Ben
 
P

Peo Sjoblom

Try formula is and something like

=AND(MID(B1,12,255)+0>=0,MID(B1,12,255)+0<=255)

post back if you need to format according anything else but the
last characters
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
Conditional Formatting 2
Counting Cells with Conditional Formatting 7
Count of Font Format 1
conditional formatting 1
Cobditional Formatting Rows based on dates in action plan. 0
Conditional formatting with dates 7
2nd condition in a conditional formatting not working 9

Top