Hi, i am looking for a forumula that will highlight cells if it is over a certain amount , i know about the if statement but it will only work with one cell, what i am looking for is this...
I have a worksheet with this sort of info
22/7 Annan 10000
22/7 Dumfries 5120
22/7 Annan 45800
23/7 Dumfries 45788
23/7 Carlisle 124588
23/7 Glasgow 400001
24/7 Annan 5200
24/7 Annan 12000
24/7 Glasgow 157800
What i want is to highlight the cells which are equal to or over 10000, however only the Annan ones, and i would like it to highlight not only the number but the whole row with the date and Annan and the number...
So what i want is somthing like =if c1>=10000 highlight a1:c1 only if a1=Annan
Sort of thing...
Is this possible... ???
(I know it is easier just to highlight the row myself with the red highlighter, but when people who dont know what they are doing are working on the file, they are forgetting that it is an issue and leaving it just normal )
Social Networking Bookmarks