LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
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 2 May 9th 23 07:42 PM
Cell data format falloutx Excel Discussion (Misc queries) 1 February 10th 06 01:46 PM
Remove Data Format Change ACFalcon Excel Discussion (Misc queries) 3 November 17th 05 06: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 01:47 AM


All times are GMT +1. The time now is 07:17 AM.

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"