Hi Folks -
I use Windows 10 & subscribe to Office 365.
I am using 64-bit Excel as my data workbook is > 0.9Gb
I have Col D with the formula =IF(OR(B2="W",B2="L",B2="ne"),NETWORKDAYS.INTL($A2,C2,"1111101"),"")
This procures the number of weekends a process (as result = Col B) took to complete,
the start time being Col A and finish time is Col C. Nothing wrong with that.... it works correctly.
The appropriate cells in Col D are blank ("") for no process or contain a numeral.
I wish to highlight each Col D cell which contains (any) number - however - when I apply the Conditional Formatting > Highlight Cell Rules > Greater than > 0.5
then ALL cells including the blanks are highlighted??? - which seems most irrational and does NOT produce the given function!
Any suggestions, please?
I use Windows 10 & subscribe to Office 365.
I am using 64-bit Excel as my data workbook is > 0.9Gb
I have Col D with the formula =IF(OR(B2="W",B2="L",B2="ne"),NETWORKDAYS.INTL($A2,C2,"1111101"),"")
This procures the number of weekends a process (as result = Col B) took to complete,
the start time being Col A and finish time is Col C. Nothing wrong with that.... it works correctly.
The appropriate cells in Col D are blank ("") for no process or contain a numeral.
I wish to highlight each Col D cell which contains (any) number - however - when I apply the Conditional Formatting > Highlight Cell Rules > Greater than > 0.5
then ALL cells including the blanks are highlighted??? - which seems most irrational and does NOT produce the given function!
Any suggestions, please?