Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-14-2017, 08:20 AM
xor xor is offline How to leave the next cell blank when a condition is met Windows 10 How to leave the next cell blank when a condition is met Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I see more problems here.

My first thought was to use conditional formatting to make all second and higher instances of "Delete Line" invisible by making the font equal to the background, but as you use different background (white and grey) that may not be an option. Could you possibly accept same background for all months?

A problem is that you doesn't seem to use real Excel dates in I7:U7 but text strings (I may be wrong here as I don't use US-settings)

I have problems understanding what it is you try to attempt. If we take a look at row 10, can you explain very simply what 47.83 and 14.88 in cells I10 and J10 mean.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - Prevent blank cell based on a condition dawd Excel 2 08-12-2015 05:44 AM
How to leave the next cell blank when a condition is met Formulato say if cell is blank do this, if not blank do this. mbesspiata Excel 1 01-17-2015 05:02 AM
How to leave the next cell blank when a condition is met Place 0 in blank cell mbesspiata Excel 5 06-20-2014 07:00 PM
Copying data from one cell to another where condition is third cell fairyca Excel 4 03-30-2014 08:22 AM
How to leave the next cell blank when a condition is met Formula in a Cell with condition? Learner7 Excel 1 07-19-2010 10:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft