| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto text colour change to green if logical function true?
Hi Guys/Gals
How can I get the text in a cell to automatically change colour from black to green when a logical function returns a 'TRUE' result? Please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to auto text colour change to green if logical function true?
Select the cell you want to change, then
go to Format -- Conditional Formatting... there you can enter the Formula which will be true or false and then you can define the format of this cell. hth Carlo On Dec 26, 8:58*am, Al wrote: Hi Guys/Gals How can I get the text in a cell to automatically change colour from black to green when a logical function returns a 'TRUE' result? Please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get a cell to change colour from a value, eg 1to7=green etc | Excel Discussion (Misc queries) | |||
| how to change colour of text in true or false formula | Excel Worksheet Functions | |||
| How do I auto change text colour in excel to reflect the value ent | Excel Worksheet Functions | |||
| Create a function to return text if two logical functions are true | Excel Worksheet Functions | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
Linear Mode
