| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text color in an IF...THEN...ELSE formula
Hi -
I have a cell with a date in it. I've conditionally formatted the text to be red if it is past a certain date. What I need to do now is change the text back to black if the date is past a certain date but the criteria in another cell is a certain criteria. I don't know how to address text color w/in a formula. Here's an idea of what I have (minus the correct way to format the text forecolor property): IF(AND(Y:Y="red", Z:Z="G"), "black", "red") The "G" is the other criteria. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color if text is = or not, to text in other column | New Users to Excel | |||
| Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
| How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
| Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
Threaded Mode
