ExcelBanter - How to display a pop message based on a cell value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to display a pop message based on a cell value (https://www.excelbanter.com/excel-programming/366870-how-display-pop-message-based-cell-value.html)

ashvik[_2_]

How to display a pop message based on a cell value

I have an excel sheet with the following columns Description an
Deliverydate.
I want all the rows to be highlighted in a particular colour (i.e.
red) 5 days before the deliverydate. Is this possible and how??

--
ashvi
-----------------------------------------------------------------------
ashvik's Profile: http://www.excelforum.com/member.php...fo&userid=2754
View this thread: http://www.excelforum.com/showthread.php?threadid=56016

ppyxl[_9_]

How to display a pop message based on a cell value

Go to Tool bar- Format-Conditional Formattin

--
ppyx
-----------------------------------------------------------------------
ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611
View this thread: http://www.excelforum.com/showthread.php?threadid=56016

All times are GMT +1. The time now is 05:28 PM.