Previous Topic Next Topic

Conditional Formatting to hide 00:00 in column

Solved/Closed
sharky9000 Posts 2 Registration date Saturday December 6, 2014 Status Member Last seen December 7, 2014 - Dec 6, 2014 at 07:11 PM
 Sharky9000 - Dec 8, 2014 at 02:48 PM
Hello,
I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a great deal of experience but can usually find a solution by searching google and trying the suggestions others have tried. This time I have come up empty and now have to swallow my pride and ask for help. Any Help would be greatly appreciated and may even help someone else who has a similar problem.
My Problem is;
I have 3 columns Column A start time (hh:mm) Column B finish time (hh:mm) Column C is total Time (hh:mm) where C is (24-A1)+B1 etc
How can I hide the value 00:00 in column C if there are no values in columns A & B
I have tried using IFBLANK on Column A
I have tried using IFBLANK on Column B
I have tried using IFBLANK on Columns A & B
I have tried conditional formatting Column C where cells = 00:00 to be White Font
But so far nothing works any help would be appreciated as I don't like looking at 00:00 I'm lost.
A B C
1 22:00 05:00 7:00
2 00:00
3 21:58 06:15 8:17
4 00:00
5 00:00
6 00:00

Thank You
Related:

3 responses

Answer 1 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 8, 2014 at 11:16 AM
Hi Sharky,

Usually I use IF formula to not show unwanted results of a formula.

In your case I would use:
=IF(AND(A1="",B1=""),"",YOUR FORMULA)

So if both A1 and B1 are empty, then display nothing.
If there is any data in either A1 or B1 then display the result of your formula.

Best regards,
Trowa
1
Sharky9000
Dec 8, 2014 at 02:48 PM
Good morning TrowaD (it's 05:23 here in Australia),
I want to say a BIG THANK YOU (I know I'm Shouting) your solution was simple, elegant and best of all it worked. Once again thank you for your help. I knew the solution would be something simple as it usually is but as you become frustrated searching and trying answers without success you fail to see the simplicity and look for the difficult.
Thank you
Sharky9000
0
Answer 2 / 3
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 6, 2014 at 11:23 PM
you cam hide rows or columns in excel
I am not sure whether you can hide individual cells..
0
Answer 3 / 3
sharky9000 Posts 2 Registration date Saturday December 6, 2014 Status Member Last seen December 7, 2014
Dec 7, 2014 at 01:33 AM
Hi venkat1926,
Thanks for your reply. I only want to hide those individual cells in column C that have 00:00 as the answer because Columns A & B have no data.
Again Thank you for your answer
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses