how can the cell color can be changed automatically when the answer is yes or no ? or when the answer in above indicated number or less?
how can the cell color can be changed automatically when the answer is yes or no ? or when the answer in above indicated number or less?
You can do this using conditional formatting. Find it on the home tab on the ribbon. select the 1st option play around with ="Yes" and ="No"
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
I didn't get it, would you please explain to me in more detail?
Here you go krkrdibo
Check the links out below.
Conditional Formatting
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks