Feb 7, 2006 #1 Myoho Geotechnical May 29, 2003 46 To highlight a cell by changing from black to red when daily level readings are plus or minus 5mm from the origional datum level.
To highlight a cell by changing from black to red when daily level readings are plus or minus 5mm from the origional datum level.
Feb 7, 2006 3 #2 SomeYahoo Military Jul 13, 2004 166 Use format -> conditional formatting. Use the "not between" test and highlight if the values are out of your range. Hope this helps. Upvote 0 Downvote
Use format -> conditional formatting. Use the "not between" test and highlight if the values are out of your range. Hope this helps.
Feb 16, 2006 Thread starter #3 Myoho Geotechnical May 29, 2003 46 Worked a treat. Thanks GensetGuy Upvote 0 Downvote
