conditional format

shodan

Active Member
Joined
Jul 6, 2005
Messages
486
Hi all,

Is it possible to do a conditional format where the condition is the format of the value?

Eg. I now formatted value 50000200 as \50000200. No I would like a format (background color red) where the condition would be " if formatted with \

fyi - The custom format used to obtain the format was "\"@

Is this possible?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
I think the answer is no, it's not possible but what is your reason for formatting this way?

You may be able to apply some other conditional formatting to achieve the same objective
 
Upvote 0
barry,

the only reason is just clarification. I'm prepararing a macro, not a vba macro but a dataload macro, to load data into oracle, and in there I always differentiate the keystrokes (beginning with \) from the commands via a color.

The dataload tool has an option to do this so it is done automatically, but I would have been nice if I could rebuild the complete thing in excel. When it is prepared in excel, I can easily import sheet into the tool.

the keystrokes don't actually have \ in front (otherwise I could have used the left function), I have it done via custom format because the macro tool copies it anyway. I guess that was for me the quickest solution, rather than a concatenation of \ and my data.
 
Upvote 0

Forum statistics

Threads
1,211,772
Messages
6,103,877
Members
447,882
Latest member
LORENA

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