how can i do this.
if the value of the cell is less than 50 it turn red if its more it turn green
thanks
how can i do this.
if the value of the cell is less than 50 it turn red if its more it turn green
thanks
Take a look at conditional formatting. This link can explain it better than I
http://www.contextures.com/xlCondFormat01.html
If you still have questions, ask away.![]()
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
thanks. i found the solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks