How do I write a formula that will change the text to an assigned color based on cell contents?
How do I write a formula that will change the text to an assigned color based on cell contents?
Last edited by curtvschultz; 01-16-2009 at 02:49 PM. Reason: Solved
That's CONDITIONAL FORMATTING, on the FORMAT menu.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you, I did it, however what if I want an entire row conditionally set to a single cell?
Inside Condition1 are two options:
Cell value Is
Formula Is
Select the entire row, then click Conditional Formatting: Formula Is: =$A$1=5 (or whatever your cell and trigger value happens to be)
Now the entire row will watch cell A1.
Select FORMULA IS and then put in the reference, for ins
Can you copy conditional formating? So i create it for a single cell then copy just the formating to other row/columns?
The $ symbols make the reference absolute. If you want to be able to use the FORMAT PAINTER to paint that conditional stuff, take the second $ symbol out.
=$A1=5
Now it will copy properly to other rows.
Can I copy just the formating? And not other contents of the cell?
FORMAT PAINTER. Looks like a paintbrush on the toolbar.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks