Change text color for all characters after the 255th character count. How to?

R

ramya_mudambi

New Member
Joined
Feb 26, 2014
Messages
5
Hi,
In Excel 2010, i'm trying to accomplish the following:
The Column named "Difference" has rows with values in cell greater than 255 character count. I'm Trying to Change text color for all characters after the 255th character count to Blue. I'm clueless of completing this :(

Kindly help !!

[TABLE="width: 1128"]
<tbody>[TR]
[TD]System[/TD]
[TD]ID[/TD]
[TD]type[/TD]
[TD]Account Status[/TD]
[TD]Full Name[/TD]
[TD]Job title/position[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]Trainer[/TD]
[TD="align: right"]1[/TD]
[TD]Valid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ADMINISTER DATABASE TRIGGER, ADMINISTER RESOURCE MANAGER, ADMINISTER SQL MANAGEMENT OBJECT, ALTER, ALTER ANY DIMENSION, ALTER ANY PROCEDURE, ALTER ANY TABLE, ALTER ANY TRIGGER, ALTER ANY TYPE, ALTER DATABASE, ALTER PROFILE, ALTER RESOURCE COST, ALTER USER, ANALYZE ANY, AUDIT ANY, AUDIT SYSTEM, BACKUP ANY TABLE, BECOME USER, COMMENT ANY TABLE, CREATE ANY CLUSTER, CREATE ANY CONTEXT, CREATE ANY CUBE, CREATE ANY CUBE BUILD PROCESS, CREATE ANY CUBE DIMENSION, CREATE ANY DIMENSION, CREATE ANY DIRECTORY, CREATE ANY INDEX, CREATE ANY INDEXTYPE, CREATE ANY JOB, CREATE ANY LIBRARY, CREATE ANY MATERIALIZED VIEW, CREATE ANY MEASURE FOLDER, CREATE ANY OPERATOR, CREATE ANY PROCEDURE, CREATE ANY SEQUENCE, CREATE ANY SQL PROFILE, CREATE ANY SYNONYM, CREATE ANY TABLE, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE ANY VIEW, CREATE DATABASE LINK, CREATE EXTERNAL JOB, CREATE JOB, CREATE PROFILE, CREATE PUBLIC DATABASE LINK, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE ROLLBACK SEGMENT, CREATE SEQUENCE, CREATE SESSION, CREATE TABLE, CREATE TABLESPACE, CREATE USER, DELETE, DELETE ANY CUBE DIMENSION, DELETE ANY MEASURE FOLDER, DELETE ANY TABLE, DROP ANY CLUSTER, DROP ANY CONTEXT, DROP ANY CUBE, DROP ANY CUBE BUILD PROCESS, DROP ANY CUBE DIMENSION, DROP ANY DIMENSION, DROP ANY DIRECTORY, DROP ANY INDEX, DROP ANY INDEXTYPE, DROP ANY LIBRARY, DROP ANY MATERIALIZED VIEW, DROP ANY MEASURE FOLDER, DROP ANY OPERATOR, DROP ANY OUTLINE, DROP ANY PROCEDURE, DROP ANY ROLE, DROP ANY SEQUENCE, DROP ANY SQL PROFILE, DROP ANY SYNONYM, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY TYPE, DROP ANY VIEW, DROP PROFILE, DROP PUBLIC DATABASE LINK, DROP PUBLIC SYNONYM, DROP ROLLBACK SEGMENT, DROP TABLESPACE, DROP USER, EXECUTE, EXECUTE ANY CLASS, EXECUTE ANY OPERATOR, EXECUTE ANY PROCEDURE, EXECUTE ANY PROGRAM, EXECUTE ANY TYPE, FLASHBACK, GLOBAL QUERY REWRITE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE, GRANT ANY ROLE, INSERT, INSERT ANY CUBE DIMENSION, INSERT ANY MEASURE FOLDER, INSERT ANY TABLE, LOCK ANY TABLE, MANAGE ANY QUEUE, MANAGE SCHEDULER, RESUMABLE, UNLIMITED TABLESPACE, UPDATE, UPDATE ANY CUBE, UPDATE ANY CUBE BUILD PROCESS, UPDATE ANY CUBE DIMENSION, UPDATE ANY TABLE, WRITE[/TD]
[/TR]
[TR]
[TD]Trainer[/TD]
[TD="align: right"]2[/TD]
[TD]Valid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ALTER PROFILE, ALTER RESOURCE COST, ALTER USER, ANALYZE ANY, AUDIT ANY, AUDIT SYSTEM, BACKUP ANY TABLE, BECOME USER, COMMENT ANY TABLE, CREATE ANY CLUSTER, CREATE ANY CONTEXT, CREATE ANY CUBE, CREATE ANY CUBE BUILD PROCESS, CREATE ANY CUBE DIMENSION, CREATE ANY DIMENSION, CREATE ANY DIRECTORY, CREATE ANY INDEX, CREATE ANY INDEXTYPE, CREATE ANY JOB[/TD]
[/TR]
[TR]
[TD]Trainer[/TD]
[TD="align: right"]3[/TD]
[TD]Valid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DROP ANY LIBRARY, DROP ANY MATERIALIZED VIEW, DROP ANY MEASURE FOLDER, DROP ANY OPERATOR, DROP ANY OUTLINE, DROP ANY PROCEDURE, DROP ANY ROLE, DROP ANY SEQUENCE, DROP ANY SQL PROFILE, DROP ANY SYNONYM, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY TYPE, DROP ANY VIEW, DROP PROFILE, DROP PUBLIC DATABASE LINK[/TD]
[/TR]
[TR]
[TD]Trainer[/TD]
[TD="align: right"]4[/TD]
[TD]Valid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ALTER PROFILE, ALTER RESOURCE COST, ALTER USER, ANALYZE ANY, AUDIT ANY, AUDIT SYSTEM, BACKUP ANY TABLE, BECOME USER, COMMENT ANY TABLE, CREATE ANY CLUSTER, CREATE ANY CONTEXT, CREATE ANY CUBE, CREATE ANY CUBE BUILD PROCESS, CREATE ANY CUBE DIMENSION, CREATE ANY DIMENSION, CREATE ANY DIRECTORY, CREATE ANY INDEX, CREATE ANY INDEXTYPE, CREATE ANY JOB[/TD]
[/TR]
[TR]
[TD]Trainer[/TD]
[TD="align: right"]5[/TD]
[TD]Valid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ADMINISTER DATABASE TRIGGER, ADMINISTER RESOURCE MANAGER, ADMINISTER SQL MANAGEMENT OBJECT, ALTER, ALTER ANY DIMENSION, ALTER ANY PROCEDURE, ALTER ANY TABLE, ALTER ANY TRIGGER, ALTER ANY TYPE, ALTER DATABASE, ALTER PROFILE, ALTER RESOURCE COST, ALTER USER, ANALYZE ANY, AUDIT ANY, AUDIT SYSTEM, BACKUP ANY TABLE, BECOME USER, COMMENT ANY TABLE, CREATE ANY CLUSTER, CREATE ANY CONTEXT, CREATE ANY CUBE, CREATE ANY CUBE BUILD PROCESS, CREATE ANY CUBE DIMENSION, CREATE ANY DIMENSION, CREATE ANY DIRECTORY, CREATE ANY INDEX, CREATE ANY INDEXTYPE, CREATE ANY JOB, CREATE ANY LIBRARY, CREATE ANY MATERIALIZED VIEW, CREATE ANY MEASURE FOLDER, CREATE ANY OPERATOR, CREATE ANY PROCEDURE, CREATE ANY SEQUENCE, CREATE ANY SQL PROFILE, CREATE ANY SYNONYM, CREATE ANY TABLE, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE ANY VIEW, CREATE CLUSTER, CREATE DATABASE LINK, CREATE EXTERNAL JOB, CREATE INDEXTYPE, CREATE JOB, CREATE OPERATOR, CREATE PROCEDURE, CREATE PROFILE, CREATE PUBLIC DATABASE LINK, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE ROLLBACK SEGMENT, CREATE SEQUENCE, CREATE SESSION, CREATE TABLE, CREATE TABLESPACE, CREATE TRIGGER, CREATE TYPE, CREATE USER, DELETE, DELETE ANY CUBE DIMENSION, DELETE ANY MEASURE FOLDER, DELETE ANY TABLE, DROP ANY CLUSTER, DROP ANY CONTEXT, DROP ANY CUBE, DROP ANY CUBE BUILD PROCESS, DROP ANY CUBE DIMENSION, DROP ANY DIMENSION, DROP ANY DIRECTORY, DROP ANY INDEX, DROP ANY INDEXTYPE, DROP ANY LIBRARY, DROP ANY MATERIALIZED VIEW, DROP ANY MEASURE FOLDER, DROP ANY OPERATOR, DROP ANY OUTLINE, DROP ANY PROCEDURE, DROP ANY ROLE, DROP ANY SEQUENCE, DROP ANY SQL PROFILE, DROP ANY SYNONYM, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY TYPE, DROP ANY VIEW, DROP PROFILE, DROP PUBLIC DATABASE LINK, DROP PUBLIC SYNONYM, DROP ROLLBACK SEGMENT, DROP TABLESPACE, DROP USER, EXECUTE, EXECUTE ANY CLASS, EXECUTE ANY OPERATOR, EXECUTE ANY PROCEDURE, EXECUTE ANY PROGRAM, EXECUTE ANY TYPE, FLASHBACK, GLOBAL QUERY REWRITE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE, GRANT ANY ROLE, INSERT, INSERT ANY CUBE DIMENSION, INSERT ANY MEASURE FOLDER, INSERT ANY TABLE, LOCK ANY TABLE, MANAGE ANY QUEUE, MANAGE SCHEDULER, RESUMABLE, UNLIMITED TABLESPACE, UPDATE, UPDATE ANY CUBE, UPDATE ANY CUBE BUILD PROCESS, UPDATE ANY CUBE DIMENSION, UPDATE ANY TABLE, WRITE[/TD]
[/TR]
[TR]
[TD]Trainer[/TD]
[TD="align: right"]6[/TD]
[TD]Valid[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DROP ANY MATERIALIZED VIEW, DROP ANY MEASURE FOLDER, DROP ANY OPERATOR, DROP ANY OUTLINE, DROP ANY PROCEDURE, DROP ANY ROLE, DROP ANY SEQUENCE, DROP ANY SQL PROFILE, DROP ANY SYNONYM, DROP ANY TABLE, DROP ANY TRIGGER, DROP ANY TYPE, DROP ANY VIEW, DROP PROFILE, DROP PUBLIC DATABASE LINK, DROP PUBLIC SYNONYM, DROP ROLLBACK SEGMENT, DROP TABLESPACE, DROP USER, EXECUTE, EXECUTE ANY CLASS, EXECUTE ANY OPERATOR, EXECUTE ANY PROCEDURE, EXECUTE ANY PROGRAM, EXECUTE ANY TYPE, FLASHBACK, GLOBAL QUERY REWRITE, GRANT ANY OBJECT PRIVILEGE, GRANT ANY PRIVILEGE, GRANT ANY ROLE, INSERT, INSERT ANY CUBE DIMENSION, INSERT ANY MEASURE FOLDER, INSERT ANY TABLE, LOCK ANY TABLE, MANAGE ANY QUEUE, MANAGE SCHEDULER, RESUMABLE, UNLIMITED TABLESPACE, UPDATE, UPDATE ANY CUBE, UPDATE ANY CUBE BUILD PROCESS, UPDATE ANY CUBE DIMENSION, UPDATE ANY TABLE, WRITE, ADMINISTER DATABASE TRIGGER, ADMINISTER RESOURCE MANAGER, ADMINISTER SQL MANAGEMENT OBJECT, ALTER, ALTER ANY DIMENSION, ALTER ANY PROCEDURE, ALTER ANY TABLE, ALTER ANY TRIGGER, ALTER ANY TYPE, ALTER DATABASE, ALTER PROFILE, ALTER RESOURCE COST, ALTER USER, ANALYZE ANY, AUDIT ANY, AUDIT SYSTEM, BACKUP ANY TABLE, BECOME USER, COMMENT ANY TABLE, CREATE ANY CLUSTER, CREATE ANY CONTEXT, CREATE ANY CUBE, CREATE ANY CUBE BUILD PROCESS, CREATE ANY CUBE DIMENSION, CREATE ANY DIMENSION, CREATE ANY DIRECTORY, CREATE ANY INDEX, CREATE ANY INDEXTYPE, CREATE ANY JOB, CREATE ANY LIBRARY, CREATE ANY MATERIALIZED VIEW, CREATE ANY MEASURE FOLDER, CREATE ANY OPERATOR, CREATE ANY PROCEDURE, CREATE ANY SEQUENCE, CREATE ANY SQL PROFILE, CREATE ANY SYNONYM, CREATE ANY TABLE, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE ANY VIEW, CREATE DATABASE LINK, CREATE EXTERNAL JOB, CREATE JOB, CREATE PROFILE, CREATE PUBLIC DATABASE LINK, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE ROLLBACK SEGMENT, CREATE SEQUENCE, CREATE SESSION, CREATE TABLE, CREATE TABLESPACE, CREATE USER, DELETE, DELETE ANY CUBE DIMENSION, DELETE ANY MEASURE FOLDER, DELETE ANY TABLE, DROP ANY CLUSTER, DROP ANY CONTEXT, DROP ANY CUBE, DROP ANY CUBE BUILD PROCESS, DROP ANY CUBE DIMENSION, DROP ANY DIMENSION, DROP ANY DIRECTORY, DROP ANY INDEX, DROP ANY INDEXTYPE, DROP ANY LIBRARY[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
Give this a try, assumes the "difference" column is column "G"

Code: 
Sub tt()
Dim lr As Long, c As Range
lr = Range("G" & Rows.Count).End(xlUp).Row
For Each c In Range("G2:G" & lr)
    c.Characters(256, Len(c)).Font.Color = vbBlue
Next c
End Sub
 
Upvote 0
Worked like a charm.

Thanks a billion :)



FormR said:
Give this a try, assumes the "difference" column is column "G"

Code: 
Sub tt()
Dim lr As Long, c As Range
lr = Range("G" & Rows.Count).End(xlUp).Row
For Each c In Range("G2:G" & lr)
    c.Characters(256, Len(c)).Font.Color = vbBlue
Next c
End Sub
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
What are tablespace, namespace?
Replies
1
Views
1K
xenou
xenou

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