Cells turn red if there is 0 between the first and last value (vba code required)

[fahadferoz]

The attached file contains a tiny fraction of a big database. The database is about Territory Sales Personnel making memo to each of the outlet from his assigned zone. Here, we need to keep in mind that though there may be more than 100 outlets in one area we need to start our analysis from the month a memo is created to a outlet. To smoothly run the business we need to see how many months gone by without making any memo to the outlet since the first memo. Hence, a red highlighting cell would be real helpful for us to see the TSO performance regarding creating memo to outlets.

Please have a look at the attached file for details.

 

[Logit]

If I understand you question, if the cell has a ZERO ( 0 ) you want it to turn red.

Use these steps:

Home tab
Conditional Formatting
Format only cells that contain
Cell Value / equal to / enter the following =0
Choose color
Ok
Apply
Ok

 

[fahadferoz]

If I understand you question, if the cell has a ZERO ( 0 ) you want it to turn red.

Use these steps:

Home tab
Conditional Formatting
Format only cells that contain
Cell Value / equal to / enter the following =0
Choose color
Ok
Apply
Ok

Please read the document or what ever comes with the message. It seems that you completely ignored the requirement (written elaborately inside the spreadsheet) by simply looking at the thread tilte.

Thanks for your intention though!

 

[Hui]

select F4:Q237
Home tab
Conditional Formatting
Use a Formula
=AND(F4<>"",F4=0)
Choose Red Format
Ok
Apply
Ok

 

[Logit]

fahadferoz:

I read your comments and as I best understood what you were seeking, responded in kind.

You may disregard my assistance as it did not fulfill your wishes.

Have a good day.

 

[fahadferoz]

Please read the document or what ever comes with the message. Ir seems that you completely ignored the message by simply looking at the thread tilte.

select F4:Q237
Home tab
Conditional Formatting
Use a Formula
=AND(F4<>"",F4=0)
Choose Red Format
Ok
Apply
Ok

Mr .Hui, Awesome reply....it Works!!