I am creating a spread sheet and in a specific cell I have entered the phrase "Enter Description Here". I want that type font to appear in RED. However, when someone over writes that cell and enters any other text, I would like that new text to appear in black. Is that possible? Kind of like an if/then statement for colors. Thanks!
Like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hello JoeBell,
Welcome to the forum.
Here is tip for Conditional Formatting: the condition to be tested must always evaluate to TRUE or FALSE.
I haven't looked at Fotis's workbook, so I may be repeating what he has shown there.
Using the formula option for the Conditional Formatting, you would use this formula and set the format to a red font:
=A1="Enter Description Here"
Cell A1 either does contain that specific text (TRUE) or it does not (FALSE).
Excel defaults to an "automatic" font color, typically black, so no need to specify a font color when the cell content changes to something different.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks