LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 788
Default How to enter formula to give warnings

How can I get a cell to give required warnings if other cells are out of range.

Warnings to show in Cell M8.

Cells B8= 1960 C8= 1860 B39= 81 . I need cell M8 to show 1 of 3
statements.
Statement 1 if C8 is greater than B8 less 100, show. Check lenght.
Statement 2 if C8 is less than B9 less 100 but greater than B39, show.
Lenght OK.
Statement 3 if C8 is less than B39, show. Check length/depth.
Statements 1 & 3 to be in red and statement 2 to be green.
Thanks
Chris
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Warnings Lynz[_2_] Excel Discussion (Misc queries) 3 August 14th 07 03:58 PM
Give RELEVANT responses to questions. DO NOT give usless list pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM
how do i set the enter key to give a horizontal movement excel tricks Excel Worksheet Functions 1 December 9th 05 09:28 PM
how to protect without getting the warnings Conditional Formatting Excel Worksheet Functions 0 November 21st 05 04:40 PM
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. qwopzxnm Excel Worksheet Functions 2 October 20th 05 09:06 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"