Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 24th 06, 04:38 PM posted to microsoft.public.excel.worksheet.functions
Dwood62
 
Posts: n/a
Default Format a cell to recognize data and change font colors accordingly

I am wanting to format cells so that automatically recognize the data being
inserted and change the font color. i.e. completed would become green, not
completed would become red.

  #2   Report Post  
Old April 24th 06, 04:54 PM posted to microsoft.public.excel.worksheet.functions
William Horton
 
Posts: n/a
Default Format a cell to recognize data and change font colors accordingly

Use conditional formats. Follow the menu path Format / Conditional
Formatting. Then complete the options. Excel help may be useful on this as
well.

For your example:
Cell Value Is - Equal To - ="Completed"
Then set the format to what you want.
Click add and add a second condition.
Cell Value Is - Equal To - ="Not Completed"
Then set the format to what you want.
ETC

Hope this helps.

Bill Horton

"Dwood62" wrote:

I am wanting to format cells so that automatically recognize the data being
inserted and change the font color. i.e. completed would become green, not
completed would become red.



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
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 1 March 11th 06 05:44 AM
Cell data format falloutx Excel Discussion (Misc queries) 1 February 10th 06 02:46 PM
Remove Data Format Change ACFalcon Excel Discussion (Misc queries) 3 November 17th 05 07:39 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
change font color of first cell in data table attached to chart momo Charts and Charting in Excel 2 February 18th 05 02:47 AM


All times are GMT +1. The time now is 06:25 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017