ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Prompt if data is not entered after so many times (https://www.excelbanter.com/excel-discussion-misc-queries/258703-prompt-if-data-not-entered-after-so-many-times.html)

AceWill

Prompt if data is not entered after so many times
 
Is it possible to highlight a cell if that data has not been entered after so
many times? For instance, if I have a column where I have entries of A,B,C,
& D and say B hasn't been entered for 7 times since the last entry of B, is
there a way to highlight that last B then? Hopefully my question is clear
enough to understand.


Pete_UK

Prompt if data is not entered after so many times
 
Will you have contiguous data in column A (or C or D) beyond the last
entry for column B?

Pete

On Mar 11, 11:26*pm, AceWill
wrote:
Is it possible to highlight a cell if that data has not been entered after so
many times? *For instance, if I have a column where I have entries of A,B,C,
& D and say B hasn't been entered for 7 times since the last entry of B, is
there a way to highlight that last B then? *Hopefully my question is clear
enough to understand.




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

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