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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text color in an IF...THEN...ELSE formula
Andrew,
You can't do it in a formula (without a VBA function), but just change the CF function to test the other criteria as well, that is only set it if it is past the certain date but not with the other criteria. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "andrewowens" wrote in message ... 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/ |
Reply |
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) |