Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello from Steved
In Column D1:D1000 I put in Kilometres What had happened a figure 124,957 was A mistake I would like to know please if the below is possble Thankyou. In Column D1:D1000 if the figure is a minus or greater than 5,000 I need to know, I am thinking that in Cell M1 if the above occurs then true if not it will read normally False, also in D1:D1000 can the cell be highlighted maybe the cell background be Blue if not then in Cell M2, M3 and so on to inform me where the mistakes are. if the above is not possible would you give me some sugguestions please. Thankyou for your time on my issue. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting for multiple situations | Excel Worksheet Functions | |||
Various dates returned for variable situations, + | Excel Worksheet Functions | |||
work customizable situations problem | Setting up and Configuration of Excel | |||
conflicitng situations in shared workbook | Excel Discussion (Misc queries) | |||
Multiple IF situations | Excel Programming |