conditional format

shodan

Active Member
Joined
Jul 6, 2005
Messages
481
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?
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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
 

shodan

Active Member
Joined
Jul 6, 2005
Messages
481
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

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