| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to update certain text in a cell according to thecell colour
Hi
How can we write a macro which helps me to update certain text based on the cell colour. Eg. If cell B2 is formatted in "Red" colour then the text should be updated as "NO" and if it is formatted as green in colour then the text must be updated as "YES"? Can the same be done for a range of cells? Also is there a way by which i can trigger a macro on filling of a cell. Means the moment i enter some text in a specific cell (say B2) a macro should get triggred. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to dictate colour of the cell and/or row | Excel Worksheet Functions | |||
| how to colour a cell green if another cell is filled with text | Excel Discussion (Misc queries) | |||
| Text Colour In Linked Cell | Excel Discussion (Misc queries) | |||
| I cannot add fill colour to any cell, or use coloured text | Excel Worksheet Functions | |||
| Update Macro: Leave Colour As Before Once Cell is Not Active | Excel Discussion (Misc queries) | |||
Threaded Mode
