What would be the appropriate situation to implement conditional formatting in my worksheet? Thanks for any assistance.
What would be the appropriate situation to implement conditional formatting in my worksheet? Thanks for any assistance.
Hi, welcome to the forum
What exactly are you trying to do?
Conditional Formatting is generally used to make cells change color, based on certain criteria...
=A1>5
=A1<>"Cat"
=A1+30>=TODAY() This would be used to test if a date in A1 is past 30 days from today
etc
It changes teh cell's appearance, not it's contents
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
hmm I just noticed this was posted in the Outlook forum, not the excel forum...is this an excel or an outlook question?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks