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. |
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. |
All times are GMT +1. The time now is 09:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com