LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default conditional format with hex2dec

You can use the CODE function to get the ASCII value of the right
character, such as:

=CODE(RIGHT(B1,1))-CODE(RIGHT(A1,1))=1

There are a couple of warnings with this, though. First, it will throw
an error if either cell is empty. Second, it give a false positive if
the first character is different for the two values, e.g., EA and FB.
However, you could build on the above statement to make a complex
statement with nested If()'s.

----

Nick Hebb
BreezeTree Software
http://www.breezetree.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hex2dec twilkers Excel Discussion (Misc queries) 2 August 17th 09 07:15 PM
How do I 'Add-In' Hex2Dec formula? Hex2Dec....Help! Excel Worksheet Functions 2 October 19th 06 04:49 PM
Hex2Dec substitue? Stuart Peters Excel Discussion (Misc queries) 1 July 29th 06 07:44 AM
EXCEL HEX2DEC conversion error Jerry Excel Worksheet Functions 4 June 16th 05 03:48 AM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"