ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   creating fomulas in excel (https://www.excelbanter.com/excel-worksheet-functions/11127-creating-fomulas-excel.html)

fathead

creating fomulas in excel
 
I have a worksheet of vehicles and i am trying to set up a fomula where when
the vehicles reach a certain mileage i would like to be reminded by a pop up
message or something similar if possible. any help would be greatly
appreciated.

Akhilesh Dalia

Hi,
You can use "Conditional Formatting" from format menu. "Conditional
Formatting" will change font size, color or cell background color etc. if
your entered value matches to criteria decided by you.

Try this and revert if any problem.

Regards

Akhilesh Dalia
akhileshdalia<athotmail<dotcom

"fathead" wrote:

I have a worksheet of vehicles and i am trying to set up a fomula where when
the vehicles reach a certain mileage i would like to be reminded by a pop up
message or something similar if possible. any help would be greatly
appreciated.


Bob Phillips

Take a look at http://www.xldynamic.com/source/xld.CF.html#basic

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fathead" wrote in message
...
I have a worksheet of vehicles and i am trying to set up a fomula where

when
the vehicles reach a certain mileage i would like to be reminded by a pop

up
message or something similar if possible. any help would be greatly
appreciated.





All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com