Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Changing font color based on the values


Hi,
How do I change the color of the font of the whole row
based on the some alphanumeric values.

To elaborate, If I see ABC in some rows, I want to set the
value to Blue, If I see DEF then Green upto 7 different
attributes.

I would not be able to do conditional formatting here( I
guess).

Thanks in advance!
Amar
Reply
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
How can I add the values based the color of font and the date Peter Gonzalez[_2_] Excel Worksheet Functions 1 April 16th 10 07:01 PM
Font color changing by itself EJamison Excel Discussion (Misc queries) 2 September 18th 08 05:34 PM
Changing Font color based on font type or size John Excel Discussion (Misc queries) 2 February 7th 08 12:50 AM
Changing Font Color bagoxc Excel Discussion (Misc queries) 2 July 17th 06 01:14 AM
I can't figure out how to add values based on font color. Laura Excel Discussion (Misc queries) 1 February 28th 06 04:28 PM


All times are GMT +1. The time now is 12:44 PM.

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

About Us

"It's about Microsoft Excel"