2016年9月23日星期五

How to Fix Problem - Correction of formula/new formula - Conditional formatting in Excel using due date and blank cell?

Correction of formula/new formula - Conditional formatting in Excel using due date and blank cell

Hello
Need assistance!
I have Microsoft Office Excel 2003.

I need help in correcting the formula/new formula for the below conditional formatting:
Items that come in for resolution need to be completed in 7 days.
I am managing this in an Excel workbook.
- Date of receipt of issue: In Column F.
Label of Column in F2.
Dates entered from F3 onwards (multiple entries for a year)
- Date of resolution of issue: In Column G.
Label of Column in G2.
Dates entered from G3 onwards (multiple entries for a year)
- If issue is not yet resolved, Column G will be blank (no entry)
- When issue is resolved, date of resolution will be entered in Column G
- I need Column G to be highlighted if (i) it is blank after 7 days (8 days or more) following the date in Column F, or, (ii) the date entered in column G is after 7 days (8 days or more) following the date in Column F
 
The formula I have at present is:
 
=OR(ISBLANK(G3),G3-F3>=8)
 
However, with this formula, if no date is entered in Column F and therefore nothing is entered in Column G (that is, no item has been received and cells should be blank with no formatting), the formula still picks up on Column G being blank and
highlights it.
Many thanks!

Solutions to the Problem Correction of formula/new formula - Conditional formatting in Excel using due date and blank cell

Download SmartPCFixer for Free Now

Hi,
I think you have asked the same or similar question sometime later as well.  Please check that post

Check memory problems

Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.

  1. Click on the Start button on the Taskbar.
  2. Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
  3. Click on Windows Memory Diagnostic Tool (in the search results).
  4. Click on "Restart now and check for problems (Recommended)".
  5. The system will restart, and you need to follow the instructions given on the screen.

Recommended Method to Fix the Problem: Correction of formula/new formula - Conditional formatting in Excel using due date and blank cell:

How to Fix Correction of formula/new formula - Conditional formatting in Excel using due date and blank cell with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: How to Fix Problem - Connection Reset by server - when downloading from microsoft.com?,Troubleshoot:continuous beeping sound on start up and cursor keeps blinking,Solution to Error: Crashes every 10-15 minutes except in safe mode.,How to Fix - create a source sheet file with data in another sheet?,Solution to Error: crashing and restarting windows explorer,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

没有评论:

发表评论

注意:只有此博客的成员才能发布评论。