Can Formula Change the Font Color?
I want to make it so if the cell starts with "Failed - .." the font color to
be red and if the cell starts with anything else, I want the font color to be blue. Is there a way to do this without running VBA? Thanks! Kenjiro Yagi |
Hi
not possible with a formula but try 'Format - Conditional Format' for this -- Regards Frank Kabel Frankfurt, Germany "Kenjiro Yagi" schrieb im Newsbeitrag ... I want to make it so if the cell starts with "Failed - .." the font color to be red and if the cell starts with anything else, I want the font color to be blue. Is there a way to do this without running VBA? Thanks! Kenjiro Yagi |
go to Functions, then Conditional Functions
It is fairly self explainitory from there, enjoy. Ron "Kenjiro Yagi" wrote: I want to make it so if the cell starts with "Failed - .." the font color to be red and if the cell starts with anything else, I want the font color to be blue. Is there a way to do this without running VBA? Thanks! Kenjiro Yagi |
All times are GMT +1. The time now is 10:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com