Help with conditonal formatting
Solved/Closed
croppman
croppman
- Posts
- 4
- Registration date
- Wednesday February 2, 2011
- Status
- Member
- Last seen
- March 1, 2011
croppman
- Posts
- 4
- Registration date
- Wednesday February 2, 2011
- Status
- Member
- Last seen
- March 1, 2011
Related:
- Help with conditonal formatting
- Conditonal format a because of values in another cell ✓ - Forum - Excel
- How to change date format in excel - Guide
- Describe the basic formatting of html documents layout. - Articles
- How to format write protected usb - Guide
- Samsung mobile format code - Guide
1 reply
TrowaD
Feb 3, 2011 at 09:22 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 3, 2011 at 09:22 AM
Hi Croppman,
quote
However it is still displayed when a date is entered but disappears when I4 is blank!
unquote
Off course it is, look at your formula: IF(I4="",""
Meaning: When I4 is blank, then result must be blank.
Try replacing the "=" by "<>".
Meaning: When I4 is not blank, then result must be blank.
Does this yield the desired result?
Best regards,
Trowa
quote
However it is still displayed when a date is entered but disappears when I4 is blank!
unquote
Off course it is, look at your formula: IF(I4="",""
Meaning: When I4 is blank, then result must be blank.
Try replacing the "=" by "<>".
Meaning: When I4 is not blank, then result must be blank.
Does this yield the desired result?
Best regards,
Trowa
Feb 15, 2011 at 05:37 AM
This is brilliant. Thank you, it makes the text disappear which now helps emmensely.
Thanks again
Croppman