Looking for help with making the following work:
I have a data sheet in which I need to be able to show where the numbers are out of range for the year. It is column D with numbers starting in row 4. If the number typed in the cell is greater than 0.4, I need the cell to turn red. Is there any way to do this? Appreciate any and all suggestions!
Last edited by Gibsonlpgt52; 01-18-2013 at 12:20 PM.
Hi Gibson and welcome to the forum
What you want can be achieved through Conditional Formatting...
1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =D4>0.4
Hope this helps
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
Thank you very much!!!
Happy to help, and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks